Forum Discussion
Convert week of the year into a date
Hy guys ! Could you help me in that issue, i need convert the number of week of year in a date, being most exactly, set up to friday from that week, example :
week number = 2 year = 2022
return shoulld be : 07/01/2022 the friday from that week
i have tried some strategies but I was not successful, there is a formula for this?
Please check here Excel WEEKNUM function – convert week number to date and vice versa (ablebits.com)
It also depends on how do you count weeks - by ISO of from 1st Jan, etc.
Please check here Excel WEEKNUM function – convert week number to date and vice versa (ablebits.com)
It also depends on how do you count weeks - by ISO of from 1st Jan, etc.
- Thank you Sergey!
wellsmatos , glad to help
- This just returns #NAME no matter what I do. I have tried using ; instead of , and removing the empty spaces.
I have year and week number and would like to have a simple date format e.g. 2022-08-15
What is the format exactly, as the linked formula just does not work? Thank you.I could only repeat the formula from mentioned post, it works
=DATE(A2,1,-2)-WEEKDAY(DATE(A2,1,3))+B2*7
