Stata listers

I am writing with a query relating to panel data for historical prices. I am trying to create a a date variable from an Excel file which contains year and weeknumber as a string. Is there a way to convert information available - year and week numebrs (as string) into Stata or Excel recognisable dates? Thanks very much.


year weeknum Price 1 Price 2 date
1890 2nd week in Jan 76 90
1890 3rd week in Jan 76 90
1890 4th week in Jan 76 90
1890 2nd week in Feb 76 90
1890 3rd week in Feb 76 90
1890 4th week in Feb 76 90
1890 2nd week in March 76 90
1890 3rd week in March 80 94
1890 4th week in March 80 94
1890 5th week in March 80 94


I am not able to attach this data in .dta format for some reason. I am using Stata MP 16.