Hi All
I would like to have a formula :- today plus 15 months
Please advice. Thanks
Hi All
I would like to have a formula :- today plus 15 months
Please advice. Thanks
Hi,
Try
=DATE(YEAR(E1),MONTH(E1)+15,DAY(E1))
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
With Analysis ToolPak function EDATE
=EDATE(TODAY(),15)
note that this could give different results to VBA Noob's suggestion when dates are near the end of the month, e.g. If today is 31st March
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks