ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   programming date functions (https://www.excelbanter.com/excel-worksheet-functions/56799-programming-date-functions.html)

Gail

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?

JE McGimpsey

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?


Ron Coderre

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