Formula Function Reference

Our Formula Function Reference

WeekdayAdd - WorkDates

Arguments: 
(WorkDate d, Number n)
Result Type: 
WorkDate
Explanation: 
Returns the date obtained by adding n weekdays to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/03/2003 since it counts 10/31/2003 as 1 day and 11/03/2003 (a Monday) as the second day.
Example: 
WeekdayAdd([Start],5) returns the date 5 weekdays after the date in the Start field. WeekdayAdd(ToWorkDate(ToDate("10/31/2003")), 2) returns 11/03/2003 WeekdayAdd([Field A], [Field B]) where Field A is a field of type WorkDate and Field B is a field of type Numeric. Assuming that the value of Field A is 10/31/2003 and the value of Field B is 2, the formula will return 11/03/2003
Tags:

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit