Thanks Harlan, this will take care of that problem nicely.

-Minitman


On 2 Dec 2005 09:21:59 -0800, "Harlan Grove" wrote:

Minitman wrote...
There are two other dates that I need. The first day of the year for
the month in question . . .

=DATE(YEAR(D),1,1)

. . . and a way to tell if the year in question is a
leap year or not (This schedule I am making spans 13 years or more).
...

=MONTH(DATE(YEAR(D),2,29))=2