How to determine the first business day of each month in the United States

[cpawelko]

Does anyone know a way to determine the first business day of each month using the US Banking Holiday calendar as holidays? I have tried using the workdays and weekdays functions but have been unable to accomplish the task. Any help would be appreciated.

Thanks.

 

[njimack]

Welcome to the board.

If your date is in A1 (e.g 01/01/12), use the following:
=WORKDAY(EOMONTH(A1,-1),1,Holidays)

(where Holidays is a list of Bank Holidays)

 

[Jonmo1]

Welcome to the board..

Try this in a cell, then filled down for 12 cells.
=WORKDAY(DATE(YEAR(TODAY()),ROWS($A$1:$A1),0),1,$H$1:$H$20)

Do not change the $A$1:$A1 - this has nothing to do with location of data or formula.
$H$1:$H$20 is a list of holiday dates you want excluded.

Yes, you have to manually create your own list of holiday dates.
There is no built in list of holidays in Excel because there are just too many variables.
What one person/company/city/state/country considers a holiday is different from the next.