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 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.
Again many thanks for your help. I only used the quotes to show what excel replied.
I copypasted the formula you had in the attachment and for some reason it worked, so thank you very much!
I have earlier encountered major issues about the US / EUR date formats, Excel interpreting dates, text and numbers wrong, and the comma/semicolon problems.
But this is now solved, thank you so much!
I copypasted the formula you had in the attachment and for some reason it worked, so thank you very much!
I have earlier encountered major issues about the US / EUR date formats, Excel interpreting dates, text and numbers wrong, and the comma/semicolon problems.
But this is now solved, thank you so much!
outsourceit , you are welcome, great to know you sorted this out.
