Calculating to add years - including leap year
 

I have a function that needs to add 3 years to a date field. I am currently
adding 1095 days (3 years x 365) to the base number, but if there is a leap
year in those three, I'm off by one day. How can I add three years and make
sure that the extra day is included if one year is a leap year?

Calculating to add years - including leap year
 

One possible way

=DATE(YEAR(F1)+3,MONTH(F1),DAY(F1))


where F1 holds the date you want to add 3 years to

Note that if the date in F1 is for instance 02/29/08 then my formula will
return
03/01/11


--
Regards,

Peo Sjoblom



"MareskiCP" wrote in message
...
I have a function that needs to add 3 years to a date field. I am
currently
adding 1095 days (3 years x 365) to the base number, but if there is a
leap
year in those three, I'm off by one day. How can I add three years and
make
sure that the extra day is included if one year is a leap year?

Calculating to add years - including leap year
 

Other users enter a date in a given cell, and I have another cell that should
calculate three years out from that date. I can't just add 1095 days... how
can I write the function to add 3 years to a different date field? I need to
get your formula below to recognize that the date for (F1) comes from another
cell.

"Peo Sjoblom" wrote:

One possible way

=DATE(YEAR(F1)+3,MONTH(F1),DAY(F1))


where F1 holds the date you want to add 3 years to

Note that if the date in F1 is for instance 02/29/08 then my formula will
return
03/01/11


--
Regards,

Peo Sjoblom



"MareskiCP" wrote in message
...
I have a function that needs to add 3 years to a date field. I am
currently
adding 1095 days (3 years x 365) to the base number, but if there is a
leap
year in those three, I'm off by one day. How can I add three years and
make
sure that the extra day is included if one year is a leap year?

Calculating to add years - including leap year
 

That's what it does

If you put a date in F1 (in my example) and format the cell with the formula
as a date you will get a date with 3 years added and it will take leap years
into consideration


--
Regards,

Peo Sjoblom



"MareskiCP" wrote in message
...
Other users enter a date in a given cell, and I have another cell that
should
calculate three years out from that date. I can't just add 1095 days...
how
can I write the function to add 3 years to a different date field? I need
to
get your formula below to recognize that the date for (F1) comes from
another
cell.

"Peo Sjoblom" wrote:

One possible way

=DATE(YEAR(F1)+3,MONTH(F1),DAY(F1))


where F1 holds the date you want to add 3 years to

Note that if the date in F1 is for instance 02/29/08 then my formula
will
return
03/01/11


--
Regards,

Peo Sjoblom



"MareskiCP" wrote in message
...
I have a function that needs to add 3 years to a date field. I am
currently
adding 1095 days (3 years x 365) to the base number, but if there is a
leap
year in those three, I'm off by one day. How can I add three years and
make
sure that the extra day is included if one year is a leap year?

Calculating to add years - including leap year
 

Try this:
=EDATE(A1,12*3)

Required Analysis ToolPak Add-Ins


"MareskiCP" wrote:

I have a function that needs to add 3 years to a date field. I am currently
adding 1095 days (3 years x 365) to the base number, but if there is a leap
year in those three, I'm off by one day. How can I add three years and make
sure that the extra day is included if one year is a leap year?