Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |