Skip to main content
Question

Automatically update a date to 5 days prior based on Due Date

  • Oct 12, 2022 4:14 PM UTC
  • 0 replies
  • 94 views
So, I have a due date entered and I want to automatically update a date 5 business days prior to that due date. Rather than me manually updated it, I'd like a formula to automatically update for me.

------------------------------
Vanessa Alexander
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    no,
    Just make a new Formula Date field called [5 Bus. days before Due Date ].

    WeekdayAdd([Due Date],-5)




    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement