Bob Klass.Info
Random stuff.
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)
‹
›
Home
View web version