View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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