Add 3 years to a date

[Simon]

I have a date:

31/12/2001

I would to be able to increase the year by 3. Is there a
simple way to go about this?

Result:

31/12/2004


Many Thanks

 

[Bob Phillips]

Hi Simon,

assuming it is A1

=DATE(YEAR(A1)+3,MONTH(A1),Day(A1))

format as date

--

HTH

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

 

[Bill Ridgeway]

If the date is in cell A1

=a1+1095

but beware this goes one day adrift if it includes a leap year February (as
in this example).

If this one day discrepancy is significant you will need to add a test to
detect whether or not the source date is within 1460 days (I think) of the
following leap year February and, if TRUE, add a day.

Regards.

Bill Ridgeway
Computer Solutions

 

[2rrs]

this will add 36 months to your date: =EDATE(A1,36)