|
|
#1
05-29-2018, 03:09 PM
|
||||
|
||||
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
|
|||
|
|||
|
Add a column where you calculate the birthday for current year
Code:
=DATE(YEAR(TODAY()), MONTH(BirthDate), DAY(BirthDate)) Code:
=DATE(YEAR(TODAY()) + (DATE(YEAR(TODAY()), MONTH(BirthDate), DAY(BirthDate))<TODAY()), MONTH(BirthDate), DAY(BirthDate)) Last edited by ArviLaanemets; 05-30-2018 at 01:06 AM.
|
|
#3
05-30-2018, 12:56 AM
|
||||
|
||||
|
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
|
|||
|
|||
|
Sorry, there was typo in both formulas (missing closing bracket for YEAR function). I corrected formulas in my previous post.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Unable to sort dates in Excel on new PC
|
freebird795 | Excel | 3 | 12-07-2014 03:06 PM |
|
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
|
rkeles | Excel | 6 | 02-04-2012 01:31 PM |
| start-stop month dates in calendar | madison320 | Project | 0 | 06-24-2011 08:15 AM |
Windows 7 32bit 
Office 2007
ArviLaanemets, both formulas worked great.
Linear Mode
