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
|