First Sunday in April is

=DATE(A1,4,1)+7-WEEKDAY(DATE(A1,4,1)-1)

where A1 holds the year


Last Sunday in October is

=DATE(A1,11,1)-WEEKDAY(DATE(A1,11,1)-1)



--
Regards,

Peo Sjoblom


"Johnny" wrote in message
.. .
Hello,

I use Excel 2000, and I'd like some help with handling dates. I want to
calculate the number of days between two dates for all the years from
January 1, 2001, to December 31, 2100. The two dates are the day
Daylight Savings Time (DST) starts and the day it ends.

Two facts: (1) DST always starts on the first Sunday in April and
always ends on the last Sunday in October. (2) Although I imagine
Excel knows this, every year in the 21st century that's divisible by 4
(2004, 2008 . . . 2096) is a Leap Year (29 days in February instead of
28). Note, however, that the year 2100 is NOT a Leap Year, which I
imagine Excel also knows.

So, how do I set up the 100 rows so they show the first Sunday in April
in one column and the last Sunday in October in the next so I can
calculate the duration of DST each year? (Tip: It's always 203 days or
210 days.)

Thanks for any help you can offer.

--Johnny
http://barelybad.com