Week of the Month

[Guest]

Hi,

Can someone help me with a formula that determines which week of the month a
specific date falls. i.e. 15/10/07 = Week 3

Thanks,

 

[Niek Otten]

It depends on what system of week numbering you'd like to use.

Look at this page of Ron de Bruin's site; you'll probably be able to get to a solution from there

http://www.rondebruin.nl/weeknumber.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| Can someone help me with a formula that determines which week of the month a
| specific date falls. i.e. 15/10/07 = Week 3
|
| Thanks,
|
|

 

[Peo Sjoblom]

With your date in A1

=CEILING(DAY(A1)/7,1)




--


Regards,


Peo Sjoblom

 

[Dave O]

This is trickier than it sounds, because a month can start on a Friday
or Saturday- does the first of that month constitute week one? How do
you define a week?

 

[Guest]

how do you define when the first week of the month starts,

if it is a work week, is week 1 the week that contains 1 or the first full
week in the month?

does your week start on Monday or sunday?

If it starts on the first no matter what day of the week it is,
=ceiling(A1/7,1)
for a date in A1

 

[Guest]

Thanks for this bj - we work a 7 day calendar so the first week of the month
is the one that contains the 1st day of the month. Though I couldn't seem to
make this work, comes up with a figure of 5367 for date 24/08/06, when I was
really just looking for 4.

 

[Guest]

Hi Niek, thanks for this. However, this seems to return the week of the
year, not month.

 

[Guest]

Hi Dave,

We work a 7 day week and the 1st week of the month is the one that contains
the 1st day of the month.

 

[Guest]

Hi Dave,
We have a 7 days per week schedule so the 1st week of the month can fall on
any day and is the one that contains the 1st day of the month.

Thanks

 

[Peo Sjoblom]

You obviously missed my answer which does what you want, just remember to
format the result as general

"With your date in A1

=CEILING(DAY(A1)/7,1)"


--


Regards,


Peo Sjoblom