View Single Post
 
Old 05-29-2018, 10:51 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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