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
|