View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Convert Month, Week, Year to date

You'll need to specify how you define the week number within a month?
Is week 1 always 1st to 7th?
Presumably the Monday of week 5 can actually fall in the next month?

Perhaps:
=DATE(C2,A2,B2*7-6)+MOD(7-WEEKDAY(DATE(C2,A2,B2*7-6),3),7)
--
David Biddulph

Pete Hay wrote:
What is the easiest way to convert three values - Month, Week, Year
to a date? Date would be the Monday of the week specified.
Pete