Dates in Excel

Solved/Closed
eskagsms Posts 24 Registration date Wednesday 9 February 2011 Status Member Last seen 30 May 2012 - 24 Mar 2011 à 01:20
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 24 Mar 2011 à 03:47
Hello, I have a list of people's birthdays in a list in Excel. I want to retain only the day and month of the birthday and get rid of the year. For example, if the birthday is on 31 Jan 1977, I want it to be taken as 31 Jan only. This will help me sort the people based on the month of birth.

Please can anyone help?

Regards,

Eskagsms

Related:

1 response

RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
24 Mar 2011 à 03:47
Make two column name Month And Date and put the formula
=month(a2) and Day(a2) respectively (suppose your date in cell a2).

Now its give you the month and date of the respective date and now you can sort accordingly.