Forum Discussion

AndrewDay's avatar
AndrewDay
Qrew Member
11 years ago

Calculating duration between two date fields but working days only?

Hi, I need a formula that calculates the duration between two date fields but only counts working day (Monday through Friday) and not just the total number days. So for example; 01-Apr-2015 to ...
Formulas and functions
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
11 years ago
No problem, there is a function for that as a formula-numeric field.


WeekDaySub([start date],[end date])
AndrewLandry's avatar
AndrewLandry
Qrew Trainee
6 years ago
I've tried this but I get "Expecting date but found workdate". Any ideas?