DAY

The DAY Function

Function Group: Date

DAY takes a date and returns an integer representing the day of the month on which it falls.

Syntax

DAY(arg1)

• arg1 is a date object or a function that resolves to a date object

Uses

To get the current day, we can call DAY with an argument of a date object.

For instance, if we want to find the current day as an integer, we can call DAY(TODAY()), with the TODAY function being the argument. This will return an integer representing the current day.

If it is the first day of the month, DAY(TODAY()) will return 1.