Home

Excel dates column ascending automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-533945%22%20slang%3D%22en-US%22%3EExcel%20dates%20column%20ascending%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-533945%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20done%20a%20spreadsheet%20in%20Excel%2C%20and%20entered%20employees%20birthdays.%20Halfway%20through%20document%20the%20dates%20have%20changed%20and%20automatically%20ascending%20by%20year%2C%20however%20it%20skips%20a%20few%20dates.%20Does%20anyone%20know%20how%20to%20fix%20this%20as%20I%20originally%20entered%20their%20birthdays.%20Please%20help%2C%20I%20don't%20want%20to%20have%20to%20re-enter%20all%20dates%20again!%20Thanks%20in%20advance!%20%3A)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-533945%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-534872%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20dates%20column%20ascending%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-534872%22%20slang%3D%22en-US%22%3E%3CP%3EMake%20sure%20the%20dates%20are%20all%20entered%20in%20the%20dame%20format.%20For%20example%20YYYY-MM-dd.%3C%2FP%3E%3CP%3EThen%20select%20the%20column%20with%20dates%20and%20apply%20the%20date%20format%20that%20you%20wish%20to%20the%20entire%20column.%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
toddmaloney
Occasional Visitor

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.