Set Due Dates Based on Day 1 of operation

CRodriguez

I am creating a basic task check list that restarts every 4 weeks.  I would like to set a task for Day 1 and automatically set all of the future task due dates based on lag time.  I am not using predecessors.  

I would appreciate suggestions. 

 

 

Andrée Starå

Hi,

Please see attached link/screenshot. (The - sign should be

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Mike Wilday

If you want those dates to be based on weeks, you would want to calculate it in days. =date1+7 is for one week past due date, and for two weeks you would use =date1+14. 

J. Craig Williams

To speed the entry of these formulas, you can (and should) use absolute referencing, like this:

=[Target Date]$1 + 1

=[Target Date]$1 + 2

Two cells can be selected and dragged down to increment them. Since that will run into weekends too, I would add another column for the lag (Text/Number)

Then the formula becomes

=[Target Date]$1 + [Lag]@row

Craig