Formula for year (leap year)

  • Thread starter Thread starter jstrickland
  • Start date Start date
J

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?
 
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.
 
Back
Top