I have an Excel sheet with a row of week numbers. It’s just each cell with a different number like: D1 contains “34”, E1 “35”, F1 “36” and so on.
Now I want to get the correct month for each week number and write it in the cell below
The result should look like this:
I need this because I have to add up all columns from each month. E.g. a column called “Sum of August” So is this step necessary or this there an easier way to do this?