Forum Discussion
Excel dates column ascending automatically
Have done a spreadsheet in Excel, and entered employees birthdays. Halfway through document the dates have changed and automatically ascending by year, however it skips a few dates. Does anyone know how to fix this as I originally entered their birthdays. Please help, I don't want to have to re-enter all dates again! Thanks in advance! :)
1 Reply
Make sure the dates are all entered in the dame format. For example YYYY-MM-dd.
Then select the column with dates and apply the date format that you wish to the entire column.
I hope this helps.
