Sort data by month and by dates

		Microsoft Office Forums > Microsoft Excel > Excel
Sort data by month and by dates

05-29-2018, 10:51 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

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.

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 PM.