Brian Dunning's FileMaker Custom Functions

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   Donald L. Merand
Exploration School
http://www.explo.org

Share on Facebook Share on Twitter

  Sample input:
WeekdaysFrom ( "02/14/2016" ; 11 )
  Sample output:
15

  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

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.