=B2+32-DAY(B2+32)-MAX((WEEKDAY(B2+32-DAY(B2+32),2)-5),0)


I'm talking to myself so just for the record the above will produce errors
towards the end of the month so use:

=(B2-DAY(B2))+32-DAY((B2-DAY(B2))+32)-MAX((WEEKDAY((B2-DAY(B2))+32-DAY((B2-DAY(B2))+32),2)-5),0)

Eight function calls? Doesn't look so good now Sandy

--

Sandy

Replace@mailinator with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Without having to install the Analysis Toolpak try:

=B2+32-DAY(B2+32)-MAX((WEEKDAY(B2+32-DAY(B2+32),2)-5),0)


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Winston" wrote in
message ...

Hi All

What is the formula for the last working day in month?

Anyone HELP?

Winston.


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