Sorting by birth month in excel
Solved
xstillgirl
-
Gigi -
Gigi -
Hello everyone,
I need an expert on Excel.
I have a list that includes the birth dates of people (dd/mm/yyyy).
My problem is that I would like to sort this by birth month to see which birthdays are in the same month.
Is this possible?
If so, how?
I warn you, I am a beginner on Excel, so creating a column is fine, but then I will need help configuring it.
Thank you for your assistance.
Configuration: Windows Vista / Firefox 3.5.11
I need an expert on Excel.
I have a list that includes the birth dates of people (dd/mm/yyyy).
My problem is that I would like to sort this by birth month to see which birthdays are in the same month.
Is this possible?
If so, how?
I warn you, I am a beginner on Excel, so creating a column is fine, but then I will need help configuring it.
Thank you for your assistance.
Configuration: Windows Vista / Firefox 3.5.11
4 answers
Hello,
If you just want to sort by month in a free column in row 2:
=MONTH(A2)
If you want to sort by month and by day in the month:
=TEXT(MONTH(A2);"00")&"-"&TEXT(DAY(A2);"00")
And if you want to display the age on the birthday:
=YEAR(TODAY())-YEAR(A2)
or
=YEAR(TODAY())-YEAR(A2) & " years on " & TEXT(DATE(YEAR(TODAY());MONTH(A2);DAY(A2));"dd-mm-yyyy")
Eric
If you just want to sort by month in a free column in row 2:
=MONTH(A2)
If you want to sort by month and by day in the month:
=TEXT(MONTH(A2);"00")&"-"&TEXT(DAY(A2);"00")
And if you want to display the age on the birthday:
=YEAR(TODAY())-YEAR(A2)
or
=YEAR(TODAY())-YEAR(A2) & " years on " & TEXT(DATE(YEAR(TODAY());MONTH(A2);DAY(A2));"dd-mm-yyyy")
Eric
Xavier
great! thanks
Gigi
Great.. It's exactly what I'm looking for, I've forgotten a lot since I retired...
