Thread: How do I get the week in month from a date?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How do I get the week in month from a date?
On Mon, 13 Jul 2009 02:05:01 -0700, Oke wrote:

I am searching for a formula to provide the week of the month given a date.
For example 13, July 2009 is the 2nd Monday in July 2009. Does anyone know a
formula/function I can use?

How are you defining the first day of the first week in a given month?
--ron
Reply With QuoteReply With Quote