Use `=DAY(A1)` to return the day number from a date in cell A1
Use `=TEXT(A1,”d”)` to display the day of the month as text
Use `=TEXT(A1,”dd”)` to display the day of the month with a leading zero
Use `=WEEKDAY(A1)` to return the day of the week as a number
Use `=TEXT(A1,”dddd”)` to display the full weekday name
Use `=TEXT(A1,”ddd”)` to display the abbreviated weekday name