Whats the Week of the Month?

C

ceemo

Is there a function or code for a function that will give me the week of
the month?
 
B

Bob Phillips

What's the criteria, does it start on 1st, first Monday, etc.?

--

HTH

Bob Phillips

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

Toppers

Assuming week 1 starts on the 1st of a month:

=INT((DAY(A1)/7)+1)

where A1 is the date

Is this what you want?
 
D

David Biddulph

Assuming week 1 starts on the 1st of a month:

=INT((DAY(A1)/7)+1)

where A1 is the date

Is this what you want?
Click to expand...

Wouldn't that always make week 1 a 6 day week?
 
C

ceemo

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

This was how it was explained to me but im thinking this ma be to muc
effor
 
B

Bob Phillips

=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)
 
Top