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
Abrazos Data Consulting, Inc.
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, 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, 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).
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.