![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 04:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com