AnsweredAssumed Answered

Calculating Number of Weekdays Going Backward from Start Date

Question asked by soar1024 on Nov 21, 2015
Latest reply on Nov 21, 2015 by Mike_Mitchell

(i.e. Business Days --eliminate holidays)

 

e.g.  As in: 10 business days prior to November 23, 2015 (start date) is November 6, 2015 (resulting date).  Takes into account 2 weekends and the November 11 (Veteran's Day holiday).

 

How do I do this?

 

-- input a date

-- input number of days

-- result date

 

(using FileMaker Pro 11)

Outcomes