ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Autopopulating a date (https://www.excelbanter.com/new-users-excel/445966-autopopulating-date.html)

KellyJane May 4th 12 04:27 AM

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?

Mazzaropi May 4th 12 07:50 PM

Quote:

Originally Posted by KellyJane (Post 1601476)
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.

Im 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.

joeu2004[_2_] May 5th 12 03:23 AM

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))




All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com