Forum Discussion
wellsmatos
Jul 13, 2022Copper Contributor
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...
- Jul 13, 2022
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.
outsourceit
Feb 28, 2024Copper Contributor
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.
SergeiBaklan
Feb 28, 2024MVP
I could only repeat the formula from mentioned post, it works
=DATE(A2,1,-2)-WEEKDAY(DATE(A2,1,3))+B2*7
- outsourceitFeb 28, 2024Copper Contributor
Many thanks for your reply. The formula just does not work, reverts #NAME
Could it be with commas and semicolons?
- outsourceitFeb 28, 2024Copper ContributorI tried replacing commas with semicolons, but to no avail.
- outsourceitFeb 28, 2024Copper Contributorwith commas: "are you not trying to write a formula?
with semicolongs: "#NAME"
I copy pasted your formula and made sure the cell references were correct. This is equally frustrating as excel no believing that I actually want to use the cell formatting I have just selected.