Autopopulating a date
 

I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically give me the date 3 months from the date in A1. I have another date in C1 and I want to automatically populate the date 6 months later in D1.

I want to be able to enter different dates in the A column with the corresponding date to follow in the B column automatically.

Can anyone help?

<<<<< HELP from BRAZIL

Dear KellyJane, Good Afternoon.

I´m not sure if I understood corretly your question.
But try this one:

_________A___________B__________C___________D_____
1___Initial Date____3 Months____Other Date____6 Months
2___01/01/2012___=Formula 1___01/10/2012__=Formula 2
2___01/01/2012___01/04/2012___01/10/2012__01/04/2013


Formula 1 -- B2 -- =IF(A2="","",EDATE(A2,3))
Formula 2 -- D2 -- =IF(C2="","",EDATE(C2,6))

Tell me if it worked for you.

Fell free to ask anything about your doubt.

Have a nice day.

Autopopulating a date
 

"KellyJane" wrote:
I need to autopopulate a future date for example;
I have a date in A1, and I want B2 to automatically
give me the date 3 months from the date in A1.

In B2: =EDATE(A1,3).

If you are using Excel 2003, EDATE is part of the ATP, an add-in which must
be installed and enabled.

If you cannot use EDATE, the following is equivalent:

=MIN(DATE(YEAR(A1),3+MONTH(A1),DAY(A1)), DATE(YEAR(A1),4+MONTH(A1),0))