Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Quote:
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.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autopopulating formulass horizontally? | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
copy date based on date -refer to date range | Excel Programming | |||
Need help autopopulating next new record with previous record data | Excel Programming |