Reply to comment
Arguments:
(Date d, Number n)
Result Type:
Date
Explanation:
Returns the date that is n weekdays past the given date d. n may be negative to move backward in time.
Example:
WeekdayAdd([Start], [Duration]) returns the date that results if you add the value in the Duration field to the date in the Start field and count only weekdays.
WeekdayAdd(ToDate("6/20/2003"), 2) returns 6/24/2003
WeekdayAdd(ToDate("6/24/2003"), -2) returns 6/20/2003
If you have a date field named "Start Date" and that field has a value of 6/23/2003, then WeekdayAdd([Start Date], -2) returns 6/20/2003
- 38547 reads
