how to incorporate WORKDAY into the following formula

[LaurenHancy]

Hi All,

I have a drop down with a specific month, my forula does the trick and displays all dates for that month, but how can I display WORKDAY's only? I am a bit stuck, your help is appreciated.

A1 = Dropdown date:

=IF(A1="","",DATEVALUE("1 "&A1))

The in next cell this formula:

=IF(F6="","",IF(MONTH(F6)<>MONTH(F6+1),"",F6+1))

Thank you

 

[BlueHornet]

Are you familiar with and have you tried the NETWORKDAYS() function in Excel? It sounds like that might help to resolve any issue that you have with counting or displaying only working days (since you can also set up holidays on another range or worksheet, and those will not be counted as "working days" as well as whatever weekend or other days you also exclude).