Brian Dunning's FileMaker Custom Functions

DateDueHolidays ( StartDate ; TransitDays ; HolidayList )

Due date from Start Date plus intervening days, adding Holidays from user-entered table

  Average rating: 4.7 (29 votes) Log in to vote

Steve Gerow   Steve Gerow
Abrazos Data Consulting, Inc.

Share on Facebook Share on Twitter

  Sample input:
DueDateHolidays ( 12/17/2007 ,30 , $$holidaylist )
  Sample output:

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

I use $$holidaylist, set at startup to all the future holidays from a user-entered table of holidays.



Shan Younker   Shan Younker, Medford, OR
Mar 5, 2009
The function works if a holiday is only one day, but if you have a mutli-day holiday, for example if the holiday is Thanksgiving and the day after and you have a one day event, the function only counts one day for the holiday. If you have a two day event then the function will return an end date that is on the weekend. I'm going to try tweaking it for these instances. I'm also going to see if I can reverse the calculation to calc a start date from an end date and duration.
Marco Carminati   Marco Carminati, Genova (ITALY)
Jan 8, 2010
Great feature, but I have a problem if my calculated without weekend days is equal to a Friday and that week I also have a holiday, in which case the result is a Saturday, so I changed the function in this way :
/ * enddateraw + holidaycount * /
WeekdaysOffset (enddateraw; holidaycount)
it seems to work(but you don't put it, in your holiday list, holidays day of the week end).

Log in to post comments.


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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: