To do it automatically, you would probably have to try Arvi's function.

My formula will allows you to show a 6 day workweek. Without doing some
SUPER crazy formula, it isn't really possible to take the holidays
out... Sorry...


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=570566