R
roke
Is it possible to calculate date from given date plus i.e. 18 months?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
=DATE(YEAR(A2),MONTH(A2)+18,DAY(A2))
Mike
=DATE(YEAR(A2),MONTH(A2)+18,DAY(A2))
Mike
G
Gary''s Student
=DATE(YEAR(A1),MONTH(A1)+18,DAY(A1))
Just be really careful if end month does not have enough days.
Just be really careful if end month does not have enough days.
I
Idoia
There's a specific formula for this in excel
=EDATE(A1,18)
This way you don't have the different-days-in-month problem
=EDATE(A1,18)
This way you don't have the different-days-in-month problem
R
Roger Govier
That's absolutely correct, but you must have the Analysis Toolpak loaded, if
using versions below XL2007
Tools>Addins>Analysis Toolpak
Some companies prohibit the use of Addins on their systems.
using versions below XL2007
Tools>Addins>Analysis Toolpak
Some companies prohibit the use of Addins on their systems.