Hi Niek,
I know that, My issue is that I have a whole year of dates from Jan 1st to
Dec 31, and on a leap year I would have one extra day. in cell A2 I input
the first day of the year say 01/01/05 and in the cell below I wrote the
formula =A2+1 and carried that formula down to get all the cells I need for
the year. On 2008 I will need an extra cell in the end for the extra year
wich will display 12/01/08 but in other years if I leave that cell it will
display the first day of the next year and I don't want it to be displayed
unless it's a leap year.
Thalia

"Niek Otten" wrote:

Hi Thalia,

With one exception (1900) Excel knows exactly which years are leap years. If
you just add 1 day, it will skip from Feb 28 to Mar 1 on one year, and to
Feb 29 in another.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"tiw" wrote in message
...
Hi,
I have a column for dates, starting with the first day of the year. I only
have to input the first day on cell A@ (say 01/01/06) and the all the days
of
the years will be display in the same column (I wrote the simple formula
=A2+1). Now the next leap year is 2008 and i don't want to have to copy
the
last row to add the extra day, I want excel to display the last row of the
date column if it's a leap year and not to display it when is not. What
should I do? Thank you
Thalia