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

Sample input:

WeekdaysFrom ( "02/14/2016" ; 11 )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
Author: Donald L. Merand
Description: Given a date, and a number of weekdays, return the number of *actual* days necessary to add that number of weekdays.
Example: Friday, Feb 12 + 2 weekdays = 4 actual days.
WeekdaysFrom("02/12/2016" ; 2) = 4
*/

Let ( 
[
	x = DayOfWeek ( StartDate );
	y = NumDays
];

Case (
	y > 5 ; Case ( 
		x = 1 ; 2 + WeekdaysFrom ( StartDate ; 5 ) + WeekdaysFrom ( StartDate ; y - 5 ) ;
		x = 7 ; 1 + WeekdaysFrom ( StartDate ; 5 ) + WeekdaysFrom ( StartDate ; y - 5 ) ;
		WeekdaysFrom ( StartDate ; 5 ) + WeekdaysFrom ( StartDate ; y - 5 )
	);
	x = 7 ; y + 1 ;
	x + y > 6 ; y + 2 ;
	y
)
)

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.

WeekdaysFrom ( StartDate ; NumDays )

Comments

Support this website.

Support this website.