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
WeekdaySub([Site Plan Returned] , [Site Plan Requested]) is not working, the formula field saves this formula with no errors but produces no result when dates are added to the two fields in the formula.   Just a blank field.