FileMaker Pro Custom Functions

/* calculates a new date by adding or subtracting days; flag for skipping weekends and holidays Variables -startDate, beginning date to start calculations from -numDays, number of days to add or subtract from startDate -loopCount, determine when to exit loop, if loopCount = numDays then calculation is finished, start at 0 - function will increment -holidayList, global with all holidays, must be populated before calling function -allowWeekends, 'true' indicates endDate can fall on a weekend or holiday, empty for skipping weekends and holidays -direction, 'b' to subtract numDays from startDate, empty to add numDays */ Let ( [ //used for calculating loop count tempEndDate = If ( direction = "b"; startDate - 1; startDate + 1 ); //'b' for backward calcs, empty for forward calcs //determine when to exit function loopCount = If ( DayOfWeek ( tempEndDate ) = 1 or DayOfWeek ( tempEndDate ) = 7 or ValueCount ( FilterValues ( tempEndDate; HolidayList )) > 0 ; loopCount ; //don't increment loop if not counting the day loopCount + 1 ); //calc end date endDate = Case (numDays = 0; startDate ; If ( allowWeekends = "true" ; If ( direction = "b"; startDate - numDays; startDate + numDays ) ; If ( direction = "b"; startDate - 1; startDate + 1))) ] ; Case ( numDays = 0 or allowWeekends = "true" ; endDate; //no looping, just give result loopCount = numDays; endDate; CalcEndDate (endDate; numDays; loopCount; holidayList; allowWeekends; direction ) //call function again as necessary ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.