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
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
Please can anyone help?
Regards,
Eskagsms
Related:
- Dates in Excel
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Marksheet in excel - Guide
- Kernel for excel - Download - Backup and recovery
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 24, 2011 at 03:47 AM
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.
=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.
