How about

=WORKDAY(DATE(YEAR(A1),MONTH(A1)+1,1),-1)

or even shorter

=WORKDAY(EOMONTH(A1,0)+1,-1)

--
Regards,

Peo Sjoblom

(No private emails please)


"swatsp0p" wrote in
message ...

Also, the WORKDAY function COUNTS the number of workdays between two
stated dates (and allows for entry of Holidays). It makes no reference
to individual days of the week. Will not work for your desired result.

HTH


--
swatsp0p


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