WorkingDateList ( StartDate ; EndDate ; HolidayList )
Returns a list of dates between StartDate and EndDate excluding any dates in HolidayList
Average rating: 2.0 (3 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Returns a list of dates between StartDate and EndDate excluding any dates in HolidayList.
It does not exclude weekends automatically, you have to include them in the holiday list or remove them after calling the function.
NOTE: it requires another function to get the list of dates. There are several you could choose from, but I used this:
Get a list of date in the range StartDtae to EndDate
// Check parameters have been entered and make a sensible range
IsEmpty( StartDate ) or IsEmpty( EndDate );
"Please fill in both fields.";
StartDate > EndDate;
"Start date must be earlier than end date.";
// If we are good then return the list of dates
EndDate > StartDate;
GetDatesInRange( StartDate; EndDate - 1 ) & "¶" & EndDate;
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.