Minor help requested for MS-Excel Spreadsheets. thanks.

Sort:
Avatar of johnmusacha

Hi, I am new to Excel Spreadsheets and was wondering how to properly format a date (Day/Month/Year, etc.) in order to be able to use the functions to sort by date.  Is there any format that is preferred?  Thanks.

Avatar of adamplenty

There may be an option in the Format menu to format cells as a date, so functions will regonise those cells as such.

Avatar of johnmusacha

Cheers.  I will check it out.

Avatar of yedddy

goo, gle

Avatar of johnmusacha

Google it for me, obviously you have nothing better to do.

Avatar of learningthemoves

https://support.office.com/en-US/Article/Format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e?ui=en-US&rs=en-US&ad=US