Microsoft Office Forums Sort data by month and by dates
 Register FAQ Search Today's Posts Mark Forums Read

#1
05-29-2018, 03:09 PM
 Marcia Windows 7 32bit Office 2007 Expert Join Date: May 2018 Location: Philippines Posts: 295
Sort data by month and by dates

How do I sort a column containing the birthdays of church members? My data column consists of birthdays of baptized members starting in 1910 and every Sunday all birthday celebrants during the week were read. I could only sort the birthdays by month and not by dates. When I perform the sort and filter commands, January 16, 1999 comes first before January 5, 2000. How do I sort so that January 5, 2000 appears before January 16, 1999?
#2
05-29-2018, 10:51 PM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 578

Add a column where you calculate the birthday for current year
Code:
`=DATE(YEAR(TODAY()), MONTH(BirthDate), DAY(BirthDate))`
or where you calculate date of next birthday
Code:
`=DATE(YEAR(TODAY()) + (DATE(YEAR(TODAY()), MONTH(BirthDate), DAY(BirthDate))<TODAY()), MONTH(BirthDate), DAY(BirthDate))`
and use the calculated column for sorting.

Last edited by ArviLaanemets; 05-30-2018 at 01:06 AM.
#3
05-30-2018, 12:56 AM
 Marcia Windows 7 32bit Office 2007 Expert Join Date: May 2018 Location: Philippines Posts: 295
Sorting of data by months and days

I tried the suggested formulas above but I couldn't make them work, it says "you have entered too many arguments for this function =Year(Serial_Number)"
#4
05-30-2018, 01:08 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 578

Sorry, there was typo in both formulas (missing closing bracket for YEAR function). I corrected formulas in my previous post.
#5
05-30-2018, 01:51 AM
 Marcia Windows 7 32bit Office 2007 Expert Join Date: May 2018 Location: Philippines Posts: 295
Sorting of data by months and days

Thank you ArviLaanemets, both formulas worked great.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post freebird795 Excel 3 12-07-2014 03:06 PM steveyjohn Excel 1 11-14-2014 06:19 PM cabot Excel 1 08-17-2012 09:41 AM rkeles Excel 6 02-04-2012 01:31 PM madison320 Project 0 06-24-2011 08:15 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:18 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top