Search code examples
google-sheetsgoogle-sheets-query

How to get month number by week number? Google Sheets

I have a column with weeknumbers incrementing from 1 to 42. Next to it I would like to have the corresponding monthnumbers from 1 to 12. So e.g. next to week 1, 2, 3 it would be month 1.

How would I achieve this in google sheets?

This is what it looks like

Best Florian

Solution

  • A week number may span a month end, so two different months for different days in the same week. ie

    Not possible.