calculate 18 months from today. In excel. How?
 

Is it possible to calculate date from given date plus i.e. 18 months?

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?

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?

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?

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?