| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate 18 months from today. In excel. How?
Is it possible to calculate date from given date plus i.e. 18 months?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate 18 months from today. In excel. How?
Hi,
=DATE(YEAR(A2),MONTH(A2)+18,DAY(A2)) Mike "roke" wrote: Is it possible to calculate date from given date plus i.e. 18 months? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate 18 months from today. In excel. How?
=DATE(YEAR(A1),MONTH(A1)+18,DAY(A1))
Just be really careful if end month does not have enough days. -- Gary''s Student - gsnu200847 "roke" wrote: Is it possible to calculate date from given date plus i.e. 18 months? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate 18 months from today. In excel. How?
There's a specific formula for this in excel
=EDATE(A1,18) This way you don't have the different-days-in-month problem "roke" wrote: Is it possible to calculate date from given date plus i.e. 18 months? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculate 18 months from today. In excel. How?
That's absolutely correct, but you must have the Analysis Toolpak loaded, if
using versions below XL2007 ToolsAddinsAnalysis Toolpak Some companies prohibit the use of Addins on their systems. -- Regards Roger Govier "Idoia" wrote in message ... There's a specific formula for this in excel =EDATE(A1,18) This way you don't have the different-days-in-month problem "roke" wrote: Is it possible to calculate date from given date plus i.e. 18 months? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate a persn's age in years & months in Excel? | Excel Worksheet Functions | |||
| dynamic calculation of months remaining given end date and today | Excel Discussion (Misc queries) | |||
| counting dates in a column that less than 6 months from today | Excel Discussion (Misc queries) | |||
| calculating number of months from today | Excel Worksheet Functions | |||
| sum values between today and 6 months prior | Excel Worksheet Functions | |||
Hybrid Mode
