Quick Tip - How To Sort By Birthday In Excel
Using Excel, learn how to sort a list of birthdays by calendar year instead of by a person's age.
Formula - =DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))
If you have a Table in Excel, you can use this formula (replace @DOB with relevant table header) - =DATE(YEAR(TODAY()), MONTH([@DOB]),DAY([@DOB]))
Go to https://www.excel-me.net/ for more Excel, Notion, and productivity tips and tricks!