Recurring weekly date

Closed
sgolds
Posts
3
Registration date
Tuesday December 23, 2014
Status
Member
Last seen
December 27, 2014
- Dec 23, 2014 at 09:26 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- Jan 5, 2015 at 11:59 AM
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

5 replies

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Dec 23, 2014 at 11:30 AM
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
0
sgolds
Posts
3
Registration date
Tuesday December 23, 2014
Status
Member
Last seen
December 27, 2014

Dec 23, 2014 at 11:51 AM
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
0
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
0
sgolds
Posts
3
Registration date
Tuesday December 23, 2014
Status
Member
Last seen
December 27, 2014

Dec 27, 2014 at 02:02 PM
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
0

Didn't find the answer you are looking for?

Ask a question
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
Jan 5, 2015 at 11:59 AM
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?
0