Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago

Calculate Duration (days) between two dates but only calculate weekdays.

Calculate Duration (days) between two dates but only calculate weekdays.  Eg. Task starts on Friday and completes on Monday.  It should be 2 days, not 4.  Omit weekend days.  

this does not work:

WeekdaySub([Site Plan Requested],[Site Plan Returned])
Forms
Formulas and functions
Relationships

12 Replies

Show More
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    9 years ago
    Hi Mark,
    Im using this formula WeekdaySub(LastDayOfMonth(Today()),FirstDayOfMonth(Today())) and the result is 21 workdays not 22 for January. Are there any exceptions to the rule? Thanks