Forum Discussion
Solved
Insane date formatting problem
Hi! So I'm having an odd issue with Excel. I have a column formatted as dates. I've tried the "Text to columns" solutions for date problems. I've customized the way the date is supposed to displa...
bobthemackerel I believe the problem lies in the fact that you are trying to enter a non-existing date. There is no such date as February 31, 2021. Excel, thus, does not recognise it. Try 2-28-21 and it will work.
bobthemackerel I believe the problem lies in the fact that you are trying to enter a non-existing date. There is no such date as February 31, 2021. Excel, thus, does not recognise it. Try 2-28-21 and it will work.
You got it! You were replying just as I was realizing what a dope I was. : )