Date & Time functions

DATE.DAY

About

Returns the Day of a Date.

Inputs:

  • anydate: array of dates

Code

M.S. Excel 
DATE.DAY = LAMBDA(anydate,
    LET(
        number_array, {1, 2, 3, 4, 5, 6, 7},
        day_array, {"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"},
        XLOOKUP(WEEKDAY(anydate, 1), number_array, day_array)
    )
);