This is frequently due to the formatting of a cell. Highlight the cell(s) you are having trouble with, and check the cell format by clicking on the “home” tab:
Then look in the “Number” section. You’ll see the format listed there. In this example, it’s set for “general”.
Change it to be “date” and it should work how you are expecting it to.
