Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-29-2018, 03:09 PM
Marcia's Avatar
Marcia Marcia is offline Sort data by month and by dates Windows 7 32bit Sort data by month and by dates Office 2007
Expert
Sort data by month and by dates
 
Join Date: May 2018
Location: Philippines
Posts: 295
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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?
Reply With Quote
  #2  
Old 05-29-2018, 10:51 PM
ArviLaanemets ArviLaanemets is offline Sort data by month and by dates Windows 8 Sort data by month and by dates Office 2016
Expert
 
Join Date: May 2017
Posts: 578
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

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.
Reply With Quote
  #3  
Old 05-30-2018, 12:56 AM
Marcia's Avatar
Marcia Marcia is offline Sort data by month and by dates Windows 7 32bit Sort data by month and by dates Office 2007
Expert
Sort data by month and by dates
 
Join Date: May 2018
Location: Philippines
Posts: 295
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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)"
Reply With Quote
  #4  
Old 05-30-2018, 01:08 AM
ArviLaanemets ArviLaanemets is offline Sort data by month and by dates Windows 8 Sort data by month and by dates Office 2016
Expert
 
Join Date: May 2017
Posts: 578
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

Sorry, there was typo in both formulas (missing closing bracket for YEAR function). I corrected formulas in my previous post.
Reply With Quote
  #5  
Old 05-30-2018, 01:51 AM
Marcia's Avatar
Marcia Marcia is offline Sort data by month and by dates Windows 7 32bit Sort data by month and by dates Office 2007
Expert
Sort data by month and by dates
 
Join Date: May 2018
Location: Philippines
Posts: 295
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Sorting of data by months and days

Thank you ArviLaanemets, both formulas worked great.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort data by month and by dates Unable to sort dates in Excel on new PC freebird795 Excel 3 12-07-2014 03:06 PM
Sort data by month and by dates Please Help. I need to sort Data A-Z not sure if i need to use Macros steveyjohn Excel 1 11-14-2014 06:19 PM
sort data in excel cabot Excel 1 08-17-2012 09:41 AM
Sort data by month and by dates Sort Data rkeles Excel 6 02-04-2012 01:31 PM
start-stop month dates in calendar 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft