Date manipulation question

N

NikkoW

Hi, everyone.

I am trying to add several months to a date in a field.

Let's say that cell C3 contains the date Aug 1, 2003.

In cell D3 I want to add 18 months to that.

I can seem to add days but not months. The online help (if you can call it
that) isn't much help beyond saying "you can manipulate dates."

Thanks in advance for the help.

Nikko
 
B

Bob Phillips

=DATE(YEAR(C3),MONTH(C3)+18,DAY(C3))

You need to be careful though as adding 18 might end up at the start of a
month after, for instance 31 May gives 1st Dec 2005.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
F

Frank Kabel

Hi
as addition to Bob to prevent this problem you may use:
=DATE(YEAR(C3),MONTH(C3)+18,MIN(DAY(C3),DAY(DATE(YEAR(C3),MONTH(C3)+18+
1,0))))
 
Top