Quote:
Originally Posted by KellyJane
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.