Place the desired month's date in a cell (e.g. B2=Dec-01-05). Use this
formula to return the last workday of the month (holidays are not
factored in--is Dec 31 a holiday?)
=IF(WEEKDAY(EOMONTH(B1,0))5,6,WEEKDAY(EOMONTH(B1, 0)))
for Dec '05, returns Friday as the last workday, as the 31st falls on
Saturday..
I believe the EOMONTH function requires the Analysis Toolpak addin from
ToolsAddins
Good Luck
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=480968