|i am attempting to transfer excel data into stata. i use stat transfer to do this. the conversion unfortunately, causes all transferred dates to be off by 4 years. i assume this is due to the excel preference that starts dates counting in 1904. however, when i uncheck this option in excel it changes all my dates to ones 4 years earlier.|
is there a way to turn off the excel option to start dates in 1904 without changing all the dates in the spreadsheet.