John, thanks. I will check the web and see if I can find something.

Thanks

"Radiolistener" wrote:

Hi Dave,

There are forumlas out on the net that convert dates to holidays. Back in
the day I wrote a Notes app and a Crystal report that does it. I had found
the formulas in some web site that had shown how to do it in Java. I can't
imagine that the formulas haven't been converted to excel or vba yets.

Seek and ye shall find :-)

John.

"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