Excel: Convert WEEKNUM() to MONTH()

I am trying to find a formula that will return the month number from a given week number. Here are some things that I have defined for my purposes:

  • The week begins on Sunday
  • A month begins on the Sunday of the week that contains the 1st of the given month
For example, I have defined that the first day of January this year is 29-Dec-2013 since 01-Jan-2014 is a Wednesday. Similarly, the first day of November is 26-Oct-2014 since 01-Nov-2014 is a Saturday. Thanks in advance for your help.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of August 11, 2014.

For more resources for Microsoft Excel