Thread
:
Last Working Day In Month
View Single Post
#
10
Sandy Mann
Posts: n/a
Last Working Day In Month
=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
Reply With Quote