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