The DAY function extracts the day value from a date. This function is commonly used to analyze and group data based on the day of the month.
Note
The input dates should be in MM/DD/YYYY format. References are also accepted as arguments.
DAY(date)date: The input date.Returns the day value from the specified date.
DAY(Open Date)Extracts the day value from the Open Date field. For example, if Open Date is 05/22/2026, the function returns 22.
.png)
