Help

Finding Draft Date before due date

Topic Labels: Formulas
981 2
cancel
Showing results for 
Search instead for 
Did you mean: 
IRS
4 - Data Explorer
4 - Data Explorer

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?

2 Replies 2

Hi @IRS - you can use this formula

WORKDAY({Due Date}, -5)

i.e. WORKDAY with a negative number of days added.

Screenshot 2019-07-29 at 22.04.31.png

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

IRS
4 - Data Explorer
4 - Data Explorer

Thanks, @JonathanBowen!