Although they sound like basic questions, I am quite surprised that many colleagues are not aware of the different ways to input date in Excel “correctly”.  I would like to understand the situation of other Excel users by putting a poll here.  Pls vote without trying in Excel.  🙂

p.s. “correct” means what you input should be interpreted as a serial number that represents a date in Excel, not a text string.

For related post, click HERE.