Forum Discussion
Date in Excel
A coworker has a list of dates she needs to enter in a spreadsheet but she would like to type in the dates without typing the slash key in between the date (example: 040121 instead of 04/01/21) and e...
That works in the sense that 110121 will be displayed as 11/01/21. But it will still be the number 110121, not a date - you cannot use functions such as EDATE, EOMONTH, WEEKDAY etc. with such values, at least not in a meaningful way.
And it won't prevent the user from entering invalid "dates" such as 65/43/21
I assumed jenniferbrookplaza would know how to convert a non-date (resulting of what I suggested) as a date value. I'm gonna edit my post with one option. Thanks for pointing this out though
Re. entries like 65/43/21 there's nothing we can do, even on a non-preformatted cell
(was just trying to help with a possible way to enter the data as she wanted)