Recurring weekly date Closed

Question

Hi, I'm wanting to set up a weekly review date for a number of rows on a spreadsheet. Each row has a different start date. I've tried WORKDAY.INTL without success

TrowaD · Answer

Hi Sgolds,

Your query is unclear to me. Can you provide some samples to show how it is now and how you foresee the result.

Best regards,
Trowa

sgolds · Answer

Thanks Trowa,
As best as I can explain it:
- If a start date is (for example) 1/12/2014
- Then review dates would be 8/12/2014; 15/12/2014; 22/12/2014 etc

Hope that is clearer.

Thanks, Steve

RayH · Answer

just add 7 to the startdate.
e.g.
startdate is in cell A1

cell A2
=A1+7

cell A3 
=A2+7

and so on
format cells as Dates

sgolds · Answer

Thanks RayH,
This is as far as I managed to get as well. I'd hoped there was a way to embed the"+7" command as a recurring function in the formula for one cell, but I suppose after all, Excel is a spreadsheet not a calendar
Kind regards, Steve

TrowaD · Answer

Hi Steve,

You can type 1/12/2014 in A1 and 8/12/2014 in A2, then select both cells and drag them down to keep the increase of 7 days. 

But I would go with RayH's suggestion.

Not sure what you are looking for. If it's short, simple and gives the right results, then it's good, right?

Recurring weekly date

5 responses

Subscribe To Our Newsletter!