Week of the Month
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
"Janet BN" wrote in message
...
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.
"bj" wrote:
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
"Janet BN" wrote:
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,
|