This was a request from one of my work managers
She wanted to convert a week number she got in a column into thier dates
Excel already have the WEEKNUM that converts a date into its week number, but the reverse is what needed here
So after my mouth was drooling while she was asking her question, I started a head, and below is the result formula
You just need to place the week number in cell B3, then paste this formula anywhere: