Minor help requested for MS-Excel Spreadsheets. thanks.

Sort:
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.

adamplenty

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

johnmusacha

Cheers.  I will check it out.

yedddy

goo, gle

johnmusacha

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

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