Hi

=IF(WEEKDAY(EOMONTH(B1,0))5,6,WEEKDAY(EOMONTH(B1, 0)))

When I copy and paste this formula in and enter 1-11-2005 I get
4-1-2005.

Can anyone HELP??

Could you not use the Workday function??

Winston


--
Winston
------------------------------------------------------------------------
Winston's Profile: http://www.excelforum.com/member.php...o&userid=28344
View this thread: http://www.excelforum.com/showthread...hreadid=480968