1 Reply Latest reply on Nov 21, 2015 3:41 PM by Mike_Mitchell

    Calculating Number of Weekdays Going Backward from Start Date


      (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)