WeekdaysFrom ( StartDate ; NumDays )
Given a date, and a number of weekdays, return the number of *actual* days necessary to add that number of weekdays.
Average rating: 4.6 (16 votes) Log in to vote
Donald L. Merand Exploration School http://www.explo.org |
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Often you need to add a number of weekdays to a given date (for example, "this form is due 5 weekdays from today"). This function returns for you, given a date and the number of weekdays you want to add, the number of *actual* days to add to your date.
Typically I use it to get another date, so for example to get the date 5 days from today:
Let (
d = Get ( CurrentDate ) ;
GetAsDate ( d + WeekdaysFrom ( d ; 5 ) )
)
Comments
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.