Forum Discussion

Qrew Member

3 years ago

How to write formula for [Due Date] minus 2 weekdays

How would I write a formula to have the system subtract two weekdays from a date field, please? My formula below will calculate 2 calendar days from the due date. So, if the due date is Monday, 5/23/2...

Formulas and functions

PeteJames

Qrew Cadet

try this

ToDate(WeekdayAdd(ToWorkDate([Due Date]),-1))

------------------------------
Pete James
------------------------------

MarkShnier__You

Qrew Legend

3 years ago

Try simply
WeekdayAdd([my date field], -2)

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------