how do I sort dates by months?
You will need to put the month(s) in a separate "helper" column and sort on
this column.
If dates are in column A then in your "helper" column put:
=MONTH(A2)
and copy down.
Sort on this column.
"David" wrote:
Hi
I have a lot of birthday dates that I want to group into months. But, I am
having difficulty to sort them by months. It keeps sorting by years!
The birthday format is dd/mm/yyyy.
Can anyone help?
|