AnsweredAssumed Answered

calculation to count/add business day - holidays and weekends

Question asked by tomhicks on Sep 21, 2017
Latest reply on Sep 23, 2017 by Orlando

Sorry, its been years since I have used filemaker, I believe v10 was the last time. I am back on a new project using FMv14, it's so improved and I'm trying to knock my training wheels off to do this again, but I'm not even sure where in the support section to post these questions.


Basically I have a STARTDATE field that I need to add 10 business days to (business days are Monday through Friday) without adding weekends and holidays (these holidays will change yearly and I will need to update them). Please help me out but keep it simple as I'm just starting to wrap my head around this again. - Thanks


Monday, January 2 - New Year’s Day

Monday, January 16 - Martin Luther King Jr. Day

Monday, February 20 - Presidents’ Day

Friday, March 31 - Cesar Chavez Day

Monday, May 29 - Memorial Day

Tuesday, July 4 - Independence Day

Monday, September 4 - Labor Day

Friday, November 10 - Veterans Day

Thursday, November 23 - Thanksgiving Day

Friday, November 24 - Day after Thanksgiving

Monday, December 25 - Christmas Day