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/22, the system should identify Thursday, 5/19/22, not Saturday, 5/21/22. 

[Due Date]-Days(2)

Thank you!

------------------------------
Tom
------------------------------
Formulas and functions

2 Replies

Sort By
  • 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 #1 Challenger
      2 years ago
      Try simply
      WeekdayAdd([my date field], -2)

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