Add 3 years to a date

  • Thread starter Thread starter Simon
  • Start date Start date
S

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
 
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)
 
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
 
Back
Top