Jul 29, 2019 12:00 PM
I need a formula that will automatically fill in a draft date that comes 5 days before the due date AND has to land on a weekday. So far I have, IF({Project Size}=“Large”, DATEADD({Activity/Due Date},-5,‘d’)). This almost works for me but say I have a due date of 8/1 and I need the draft submitted for review no later than 7/26 (for a 5 workday review) how do I write the formula to land on that date and move dates according to due dates that follow?
Jul 29, 2019 02:06 PM
Hi @IRS - you can use this formula
WORKDAY({Due Date}, -5)
i.e. WORKDAY with a negative number of days added.
Note that this gives a date of 5 working days before your due date, but not including your due date (which your example above seems to include), so you may need to change this to:
WORKDAY({Due Date}, -4)
JB
Jul 29, 2019 02:26 PM
Thanks, @JonathanBowen!