Show Month from Week #
I'm creating a helper column that needs to show what month a week number was from.
For Example, I have a sheet with a [Date] column and [Week #] column.
I have second sheet that has a Week # and is pulling data from my first sheet based on a calculation using Week #.
In the second sheet, I'd like to create a helper column that displays the Month that the Week # is from, I.E. - Week 1 = January, Week 6 = Feb, etc...
Can this be done with a formula?
Help Article Resources
Check out the Formula Handbook template!