Forum Discussion

VanessaAlexande's avatar
VanessaAlexande
Qrew Member
3 years ago

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

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. ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
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
------------------------------
VanessaAlexande's avatar
VanessaAlexande
Qrew Member
3 years ago
You're awesome. Thank you so much!

------------------------------
Vanessa Alexander
------------------------------