Formula for year (leap year)

[jstrickland]

I need to write a formula that increases by one year. I
can't add 365 days to the original date because that
doesn't account for leap years. Any ideas?

 

[Norman Harker]

Hi jstrickland!

With the date in A1 try:

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave R.]

Try
EDATE(A1,12)