Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date
I input the date (A1) cell is 15-Jan-05, how to make the date value(A2) cell
is plused 3 months, the function is???? |
#2
|
|||
|
|||
Hi,
=EDATE(A1,3). Analysis Toolpak needs to be installed for this to work: Tools - Addins - Analysis Toolpak. Install the toolpak before inserting the function. Regards, A -- We are what we repeatedly do. Excellence, therefore, is not an act, but a habit. "Andrew Lau" wrote: I input the date (A1) cell is 15-Jan-05, how to make the date value(A2) cell is plused 3 months, the function is???? |
#3
|
|||
|
|||
=DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))
Note that you may get unexpected results, like when A1 is Nov 30 -- Kind regards, Niek Otten Microsoft MVP - Excel "Andrew Lau" <Andrew wrote in message ... I input the date (A1) cell is 15-Jan-05, how to make the date value(A2) cell is plused 3 months, the function is???? |
#4
|
|||
|
|||
If you want the last day of the month, x months forward, you could also use
EOMONTH (as mentioned in other posts it needs the Analysis Toolpack loaded). Can look at http://www.auditexcel.co.za/date.html to see how to use the Date functions and other another page shows how to load the Analysis Toolpack. "Andrew Lau" wrote: I input the date (A1) cell is 15-Jan-05, how to make the date value(A2) cell is plused 3 months, the function is???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel |