DAY

Definition: DAY is a function that returns the day of the month for a specified date.

Syntax: =DAY(date)

Situation: This formula is suitable when you need to retrieve the day of the month from a date.

Example: If you have a date January 1, 2021, the day of the month can be found using the formula =DAY(“1/1/2021”), which returns 1.