CREATE A FORMULA TO INCORPORATE LEAP YEARS

  • Thread starter Thread starter Alan Paterson
  • Start date Start date
A

Alan Paterson

I am trying to prepare a spreadsheet incorporating annual
columns each column headed by the date
(example 01 - Apr - 03). Currently an example of the
formula I use is (=A1+365) and copy that formula into all
subsequent column headings.

The problem occurs when we reach a leap year and of course
need to add 366 days every 4 years. Does anybody have a
formula that will achive this?

Thank you
 
Alan

Let Excel do the hard work :-)

In B1 enter:
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

Copy B1 to the right by dragging the fill handle
(the little square in the lower right corner of the cell)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.
 
Back
Top