Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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
Related:

5 responses

Answer 1 / 5
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
Answer 2 / 5
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
Answer 3 / 5
RayH
Dec 27, 2014 at 11:41 AM
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
Answer 4 / 5
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
Answer 5 / 5
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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