Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10

Hi,

In cell P10, try =P9+7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ash3154" wrote in message
...
Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10

Simply add 7: if 2/9/09 is in O10 then enter =O10+7 in P10!

Regards,
Stefi

€žash3154€� ezt Ã*rta:

Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10

Suppose in A1 you have entered: 2009/02/09
To show 1 week later:
A2=A1+7

--
R. Khoshravan
Please click "Yes" if it is helpful.


"ash3154" wrote:

Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10

Sorry, I should have provided more details:

I would like to keep looping this over and over again, as I would like to
show the new date in cell P10:
so for example if today is Feb 09 2009 (Monday), next week in P10 should be
2/16/09, but if today is 2/17 or 2/19, than the P10 should read 2/23/09.

If someone starts on Friday -- 2/20/09, next week in P10 should read 2/27/09
and than if I open the spreadsheet on 3/10/09 the date should read 3/13/09.

Thank you for the quick responses.
Ash

Thanks

"Ashish Mathur" wrote:

Hi,

In cell P10, try =P9+7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ash3154" wrote in message
...
Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10

Sorry, I should have provided more details:

I would like to keep looping this over and over again, as I would like to
show the new date in cell P10:
so for example if today is Feb 09 2009 (Monday), next week in P10 should be
2/16/09, but if today is 2/17 or 2/19, than the P10 should read 2/23/09.

If someone starts on Friday -- 2/20/09, next week in P10 should read 2/27/09
and than if I open the spreadsheet on 3/10/09 the date should read 3/13/09.

Thank you for the quick responses.
Ash


"Ashish Mathur" wrote:

Hi,

In cell P10, try =P9+7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ash3154" wrote in message
...
Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10

Sorry, I should have provided more details:

I would like to keep looping this over and over again, as I would like to
show the new date in cell P10:
so for example if today is Feb 09 2009 (Monday), next week in P10 should be
2/16/09, but if today is 2/17 or 2/19, than the P10 should read 2/23/09.

If someone starts on Friday -- 2/20/09, next week in P10 should read 2/27/09
and than if I open the spreadsheet on 3/10/09 the date should read 3/13/09.

Thank you for the quick responses.
Ash


"Ashish Mathur" wrote:

Hi,

In cell P10, try =P9+7

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ash3154" wrote in message
...
Basically, the Start of week can be any give day (ie Friday, or Sunday, or
Monday).
If the week starts on 2/9/09, than I would like to show next week will be
(2/16/09) in cell p10