Recurring weekly date
Closed
sgolds
Posts
3
Registration date
Tuesday 23 December 2014
Status
Member
Last seen
27 December 2014
-
23 Dec 2014 à 09:26
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 5 Jan 2015 à 11:59
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 5 Jan 2015 à 11:59
5 responses
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
23 Dec 2014 à 11:30
23 Dec 2014 à 11:30
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
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
Posts
3
Registration date
Tuesday 23 December 2014
Status
Member
Last seen
27 December 2014
23 Dec 2014 à 11:51
23 Dec 2014 à 11:51
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
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
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
e.g.
startdate is in cell A1
cell A2
=A1+7
cell A3
=A2+7
and so on
format cells as Dates
sgolds
Posts
3
Registration date
Tuesday 23 December 2014
Status
Member
Last seen
27 December 2014
27 Dec 2014 à 14:02
27 Dec 2014 à 14:02
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
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
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
5 Jan 2015 à 11:59
5 Jan 2015 à 11:59
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?
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?
