SOLVED

Convert week of the year into a date

New Contributor

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?

 

 

3 Replies
best response confirmed by wellsmatos (New Contributor)
Solution

@wellsmatos 

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