Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
programming date functions
I need my cells to auto date 30 days from the date in the first cell 60 days
from the date in the 2nd and so on. How do I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
programming date functions
One way:
A2: =A1+30 A3: =A2 + 60 Format as dates. In article , "Gail" wrote: I need my cells to auto date 30 days from the date in the first cell 60 days from the date in the 2nd and so on. How do I do this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
programming date functions
Try this:
If your first date is in A1, then A2: =A1+30 Copy cell A2 down as far as you need. Does that help? *********** Regards, Ron "Gail" wrote: I need my cells to auto date 30 days from the date in the first cell 60 days from the date in the 2nd and so on. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Date Functions | Excel Worksheet Functions | |||
Worksheet Revision Date only once that day | Excel Discussion (Misc queries) | |||
Date functions | New Users to Excel | |||
search for latest date | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |