Forum Discussion
Solved
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 re...
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.
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 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.