Number of week of the month

[Guest]

Does anyone know how to pull the number of week of the
month. in other words, I would like to show a number that
represents which number of week it is in relation to the
month, ex: 9/15/03 is the 3rd week of the month. I know
how to pull the number of week of the year, but the month
I am really puzzled about.

Thanks,
Eli

 

[Eli]

-----Original Message-----
Use Integer division to divide by 7. Then add 1 so the first week is 1, not
zero:

=(Day([MyDate]) \ 7) + 1

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Does anyone know how to pull the number of week of the
month. in other words, I would like to show a number that
represents which number of week it is in relation to the
month, ex: 9/15/03 is the 3rd week of the month. I know
how to pull the number of week of the year, but the month
I am really puzzled about.

Thanks,
Eli

.
Thanks for the reply, so simple I feel like slapping

myself. However, when I have dates that are 4 and above
they cause access to round the number up and give wrong
relults. also I noticed that I get wrong results anytime
I there is rounding problems. I tried changing the
decimal places, no help. Tried using the round function,
does the same thing. I guess I could use the IIF
statment, but wanted to know if there is simpler way?

Thanks again,