leap year question

[Guest]

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

 

[Bob Phillips]

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)

 

[Niek Otten]

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

 

[Guest]

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

 

[Guest]

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]

see my response

--

HTH

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