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)


Please check here Excel WEEKNUM function – convert week number to date and vice versa (

It also depends on how do you count weeks - by ISO of from 1st Jan, etc.

Thank you Sergey!

@wellsmatos , glad to help