Whats the Week of the Month?
 

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


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

Whats the Week of the Month?
 

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)

"ceemo" wrote in
message ...

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


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

Whats the Week of the Month?
 

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?

"ceemo" wrote:


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


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

Whats the Week of the Month?
 

"Toppers" wrote in message
...

"ceemo" wrote:
Is there a function or code for a function that will give me the week of
the month?

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?

Wouldn't that always make week 1 a 6 day week?
--
David Biddulph

Whats the Week of the Month?
 

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

Whats the Week of the Month?
 

You're right .... should be

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

Thanks

"David Biddulph" wrote:

"Toppers" wrote in message
...

"ceemo" wrote:
Is there a function or code for a function that will give me the week of
the month?

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?

Wouldn't that always make week 1 a 6 day week?
--
David Biddulph

Whats the Week of the Month?
 

=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