Wednesday, June 08, 2016

Setting a Due Date

This formula worked real well as


  • a calculated default value 
  • on a date only field 
  • to set the due date to today plus two 
  • and accounting for weekends:


=Today+2+IF(OR(WEEKDAY(Today)=4,WEEKDAY(Today)=5,WEEKDAY(Today)=6),2,0)+IF(WEEKDAY(Today)=7,1,0)

No comments:

Post a Comment