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

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

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

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

Thanks

"Gord Dibben" wrote:

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

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

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

On Thu, 11 Sep 2008 08:58:08 -0700, Dave
wrote:

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

Thanks

"Gord Dibben" wrote:

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