|I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected.|
Here is my formula:
where the cell A2 contains the date 11/23/1982
However, in the results, it is appearing as 30278.
The most frustrating part is I did the same formula in another spreadsheet and it worked as expected! The dates in that spreadsheet showed in the date format. Unfortunately, I did not save the other spreadsheet since that was just a draft to get the identifier.
message edited by luthientinuviel