How to highlight cells based on the week number;For example, if I have the week number "2" in one cell and the year 12 in another, I want Excel to automatically give the month for that week, January (or 1) in a third cellGet Month By Changing Formatting By changing a date's Date Format to "MMMM" you can see the month name or "MMM" to see the month abbreviation Note This will display the month name, but the value stored in the cell will still be the month number
How To Convert Month Name To Number In Excel