Skip to main content
Question

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

  • May 19, 2022
  • 0 replies
  • 87 views
Forum|alt.badge.img+3
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
------------------------------
Tom
This topic has been closed for replies.

  • PeteJames
  • Quickbase Alumni
  • May 19, 2022
try this

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

------------------------------
Pete James
------------------------------
Terms & ConditionsAccessibility statement