CREATE A FORMULA TO INCORPORATE LEAP YEARS

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
 
L

Leo Heuser

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create dates for year, allow for leap year 8
If a date range contains a leap year (date) 14
Date Formula - in Years 3
define leap year 1
How to determine if year is a leap year 7
leap year date issue in sumif formula 2
Make manually changed pivot table column headings work for other u 0
Determining a leap year 22

Top