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