Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) | |||
Excel date function | Excel Worksheet Functions | |||
Is there a function to show future date | Excel Worksheet Functions | |||
Date Function | Excel Worksheet Functions | |||
Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) |