Quickbase Discussions

 View Only
  • 1.  How to write formula for [Due Date] minus 2 weekdays

    Posted 05-19-2022 12:59
    Edited by Tom Gause 05-19-2022 13:26
    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
    ------------------------------


  • 2.  RE: How to write formula for [Due Date] minus 2 weekdays

    Posted 05-19-2022 15:22
    try this

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

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



  • 3.  RE: How to write formula for [Due Date] minus 2 weekdays

    Posted 05-20-2022 07:50
    Try simply
    WeekdayAdd([my date field], -2)

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