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: ...
Forms
Formulas and functions
Relationships
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