Return to FileMaker.com
How to calculate elasped business days
I am trying to calculate a due date based on number business days. So I want to skip the weekend days but not report on the following Monday, but with the total number of work days projected.
I have tried other formulas here, but the most applicable is not working past the next Monday after a weekend.
This is my current attempt:
access date + response calc + Middle ("1000002"; Mod (access date + response calc - Date (1;3;1904);7) +1;1)
access date is a date field
response calc is calc field, number result
Any input appreciated.
Retrieving data ...