jboulton98
New Member
- Joined
- Aug 11, 2014
- Messages
- 9
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:
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.
- 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.