AnsweredAssumed Answered

Caclulating weekdays in a date range

Question asked by MikeWile on Aug 12, 2016
Latest reply on Aug 12, 2016 by philipHPG

Is there an accurate formula to calculate the weekdays in a range? I went to Calculating Number of Weekdays (Work Days) Between Dates | FileMaker but it doesn't calculate correctly. If I enter 8/1/2016 as start and 8/12/2016 I get 9; it should be 10. If I enter 8/1/2016 as start and 8/13/2016 I get 10, which is corrrect as 8/13/2016 is a Saturday.

Outcomes