Forum Discussion

Copper Contributor

Jan 04, 2024

Sorting and Formatting Dates Formula

Hi! I am pulling data from one sheet (Current Employees) in a workbook to a new sheet (Anniversaries). I want to sort a column of dates by month and day. The original data is in a m/d/yyyy format (ex...

Formulas and Functions

PeterBartholomew1

Silver Contributor

Jan 04, 2024

This interprets the data as the date of birth and then sorts by birthday order within the coming year.

= LET(
    dob,             EmployeeTbl[DoB],
    birthday,        DATE(2024, MONTH(dob), DAY(dob)),
    requiredColumns, CHOOSECOLS(EmployeeTbl, {1,2,3,5,6,17,28,29,30}),
    SORTBY(requiredColumns, birthday)
  )