Excel Tips & Trivia: Serial Dating in Excel
This week’s trivia… Have you ever had Excel translate a date into a seemingly random number? Maybe you enter 4/30/10 and Excel transformed it (against your will, I might add) into 40298. How the heck did it come up with that number? Curiosity strikes you so you enter 5/1, 5/2 and so on…until a pattern…