I have a data set that lists work week, and I am trying to convert this number into a calendar date. I know JMP has a function to convert calendar date into work week, but I would like to do the opposite.
For example, I have a number like 201334, representing YYYYWW. How can I convert this back into a date? My reason is that I would like to be able to plot this data on a time trend, but without large gaps between years (for example from 201252 to 201301).
I am sure I can do this by calculating the number of seconds from 1/1/1904, but I am starting to get a headache trying to account for leap years, week starting days, and whatnot. I hope there is an easier way to do this.