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.