=INT((M1-(DATE(YEAR(M1),MONTH(M1),1)-WEEKDAY(DATE(YEAR(M1),MONTH(M1),1),2)+1
))/7)+1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"ceemo" wrote in
message ...

well the original requirement was that if the 1st was between a thursday
and a sunday inclusive then that should be week four and the following
week, week 1. If the first was between a monday and wednesay day then
that would count as week one.

This was how it was explained to me but im thinking this ma be to much
effort


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=567094