Hi Bob,
Thank you, I used the second formula and it works, I tried the first one and
I don't know why it didn't work.
Thalia

"Bob Phillips" wrote:

use a formula in A2 of

=A1+(YEAR(A1+1)=YEAR(A1)

and copy down to A366


or even just put =IF(YEAR(A365+1)=YEAR(A365),A365+1,"") in A366

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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