Forum Discussion

TomGause's avatar
TomGause
Qrew Member
2 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's avatar
PeteJames
Qrew Cadet
2 years ago
try this

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

------------------------------
Pete James
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    Try simply
    WeekdayAdd([my date field], -2)

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