Link to home
Start Free TrialLog in
Avatar of SerinaStar
SerinaStarFlag for Australia

asked on

Sort Dates in Excel Spreadsheet

Hi,

I am trying to use the custom list function to sort a range of dates in a spreadsheet. The dates are formatted as dd/mm/yyyy. However I must be missing somthing as they are sorting in day and not month.

Is there a quicker way of doing this?

With Thanks
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SerinaStar

ASKER

Ah you are right....sorry I didn't even think of that. Your advise works perfectly. Thanks very much :)