I have a range of dates from ~1950 to the present that are in the 5 digit Excel/Microsoft date code. I'd like to create date ranges.
I'm looking for something like
recode date into year
(42005 thru 42369) = 2015
(the above syntax might be off by a bit, but you get the picture!)...