Formula to check if a date is a holiday

[Dave]

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

 

[Gord Dibben]

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

 

[Radiolistener]

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]

Gord, thank you for the information. I was afraid this was the answer I
would receive.

Thanks

 

[Dave]

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

Thanks

 

[Scott]

Someone at my work just built an excel app to create payday calendars,
and it calculates holidays also. If you don't find anything on the
net, let I can get the code from him, may be able use part of it.

Scott