Whats the Week of the Month?
"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
|