Forum Discussion
toddmaloney
May 06, 2019Copper Contributor
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 ...
Celia_Alves
May 06, 2019MVP
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.