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

    Calculating Number of Weekdays Going Backward from Start Date

    soar1024

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