|According to the DATEDIF function, 4/11/4617 is 956,029 days after 10/04/1999.|
If the same factor was use to change the other dates, then this should convert them back:
1 - Enter 956029 in an empty cell.
2 - Ctrl-c to Copy
3 - Select your "weird" dates
4 - Edit...PasteSpecial...Subtract
5 - Format the 5 digit numbers as Date (or Custom) to format them to fit your needs.
If you don't think that the same factor was used to convert all of the dates, and you have no idea what the original dates were, then I don't think there's any way to fix your spreadsheet.
Logic dictates that you have to know 2 out of 3 things:
1 - The converted date (known)
2 - The orignal date (known for the example you supplied)
3 - The conversion factor (determined by the example you provided)
If you don't know any of the other original dates and you don't know if the same conversion factor was applied to all dates, then I think you are in deep doo-doo. (That's a technical term)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.