weeknum for month

M

maryj

I know I've done this before but can't remember how.

How do you find the number of the week in a given month?
 
D

duane

well it depaneds on how you define the week number.

If the 8th marks the start of the 2nd week, and so on then just take
int(day(the date)/7)

if you want the "wweks" to all start on Monday, for example it's more
complicated
 
M

maryj

Maybe I am mistaken that I have done this before - thought I had, but who
knows. I would want May 2, 2006 to be week 1, May 10th to be week 2, etc.
 
Top