If you're looking for some built-in function that knows which days of the
year are holidays, you're out of luck.

Excel knows when a Leap Year occurs and that's it.


Gord Dibben MS Excel MVP

On Wed, 10 Sep 2008 16:23:01 -0700, Dave
wrote:

I have put together a file to generate quick projects schedules for my work.
At the point in a project that I would use this file, we don't need the
detail of a full on MS Project schedule. I used the text formula
=text(A1,"ddd") to check my dates so I can quickly verify the dates don't
fall on the weekend.

Is there a formula that I can use that checks if a date is a Federal
Holiday. For example: If I type 12/25/08 in A1, is there a formula that
would return Christmas in B1? I have looked at the Networkdays formula but I
don't want to have to create a list of holidays that has to be maintained or
write an if statement that evaluates the dates (not using Networkdays).

Any help is apprciated.

Thanks