Previous Topic Next Topic

Dates in Excel

Solved/Closed
eskagsms Posts 24 Registration date Wednesday February 9, 2011 Status Member Last seen May 30, 2012 - Mar 24, 2011 at 01:20 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Mar 24, 2011 at 03:47 AM
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

Answer 1 / 1
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Mar 24, 2011 at 03:47 AM
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.
1

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses