Date function
 

I need to set up a spreadsheet that would look something like the following:

Subject # Day 1 Day 2 Day 8 Day 15
Day 22
May 17,2005

I want to put a function in each of the remaining columns that when I enter
the date in Day1 for each subject, excel will calculate the date for me. For
example if I enter May 17th as Day 1, excel will complete the other dates by
adding 1 day to the date in Day 1 to give me May 18th, add 7 days to Day 1 to
give me May 24 in the cell for Day 8 etc. I am using Excel 2003.

Thanks very much for your help.

Best regards,

Dee

Hi, Dee. If Day 1 is B2...

Day 2: =B2+1
Day 8: =B2+7
Day 15: =B2+14

If you don't want errors...

=If(isblank(b2),"",b2+1)
=If(isblank(b2),"",b2+7)

and so on.

*******************
~Anne Troy

www.OfficeArticles.com


"Dee" wrote in message
...
I need to set up a spreadsheet that would look something like the
following:

Subject # Day 1 Day 2 Day 8 Day 15
Day 22
May 17,2005

I want to put a function in each of the remaining columns that when I
enter
the date in Day1 for each subject, excel will calculate the date for me.
For
example if I enter May 17th as Day 1, excel will complete the other dates
by
adding 1 day to the date in Day 1 to give me May 18th, add 7 days to Day 1
to
give me May 24 in the cell for Day 8 etc. I am using Excel 2003.

Thanks very much for your help.

Best regards,

Dee

=$A$2+RIGHT(B$1,LEN(B$1)-FIND(" ",B$1))

assuming day 1 date in A2, lables in B1, C1, etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dee" wrote in message
...
I need to set up a spreadsheet that would look something like the
following:

Subject # Day 1 Day 2 Day 8 Day 15
Day 22
May 17,2005

I want to put a function in each of the remaining columns that when I
enter
the date in Day1 for each subject, excel will calculate the date for me.
For
example if I enter May 17th as Day 1, excel will complete the other dates
by
adding 1 day to the date in Day 1 to give me May 18th, add 7 days to Day 1
to
give me May 24 in the cell for Day 8 etc. I am using Excel 2003.

Thanks very much for your help.

Best regards,

Dee