Forum Discussion

JustinFinkelste's avatar
JustinFinkelste
Qrew Member
5 years ago

How do I define work days

For one of my formulas, I need to count our specific work days between 2 dates. Our work days are only: Sunday Monday Tuesday Wednesday Please help!
Formulas and functions
PaulPeterson2's avatar
PaulPeterson2
Qrew Trainee
5 years ago
This should give you a good starting point:

If(DayOfWeek(endDate) > 3, 0, ToDays(NextDayOfWeek(startDate, 3) - startDate)) +
(Int(ToDays(If(ToDays(endDate - NextDayOfWeek(endDate, 0)) = 7, endDate, NextDayOfWeek(endDate, 0)) - If(ToDays(NextDayOfWeek(startDate, 6) - startDate) = 7,  startDate, NextDayOfWeek(startDate, 6))) / 7) * 4 )+ If(DayOfWeek(endDate) > 3, 0, ToDays(endDate - PrevDayOfWeek(endDate, 0)))​


------------------------------
Paul Peterson
------------------------------
PaulPeterson2's avatar
PaulPeterson2
Qrew Trainee
5 years ago
Sorry, just noticed an error.  

Try This instead:

If(DayOfWeek(startDate) > 3, 0, ToDays(NextDayOfWeek(startDate, 3) - startDate)) +
(Int(ToDays(If(ToDays(endDate - NextDayOfWeek(endDate, 0)) = 7, endDate, NextDayOfWeek(endDate, 0)) - If(ToDays(NextDayOfWeek(startDate, 6) - startDate) = 7, startDate, NextDayOfWeek(startDate, 6))) / 7) * 4 )+ If(DayOfWeek(endDate) > 3, 0, ToDays(endDate - PrevDayOfWeek(endDate, 0)))

------------------------------
Paul Peterson
------------------------------