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.
I could only repeat the formula from mentioned post, it works
=DATE(A2,1,-2)-WEEKDAY(DATE(A2,1,3))+B2*7
Many thanks for your reply. The formula just does not work, reverts #NAME
Could it be with commas and semicolons?
- I tried replacing commas with semicolons, but to no avail.
- with 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.That could be since you use curve apostrophes " instead of normal one ", whatever. Could you please share if not the file when at least screenshot?
Or try to open attached file and check how the formula in C2 looks in your environment.