Forum Discussion

AmyGosz2's avatar
AmyGosz2
Qrew Cadet
7 years ago

I need to calculate a due date based on the month end date but excluding weekends and holidays.

I need to calculate a due date based on the month end date but exclude weekends/holidays. The actual due date could be before or after the month end date. For example, month end is 6-30-18. A task ...
Formulas and functions
UrsulaLlaveria's avatar
UrsulaLlaveria
Qrew Assistant Captain
6 years ago
Amy, were you able to figure this out? We are coming across a similar issue, trying to calculate a due date to include only workdays and exclude Federal Holidays. We have figured out the workdays, but still haven't come up with an easy solution for holidays that isn't user friendly.

------------------------------
Ursula
------------------------------
BrandonDrake's avatar
BrandonDrake
Qrew Cadet
6 years ago
Hello Ursula, 

If you are already taking the vacations into account, which it seems you are, you could wrap the entire result in ToWeekdayP. 

ToWeekdayP(WeekdayAdd([First Day of Next Month], ($DaysToFollowUp + $Holidays)))

This would ensure that whatever day you calculate from your current formula will go to the previous weekday if it lands on a weekend... 

------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------