DAY
Formula Explanation
Returns the day of the month, a number from 1 to 31, for a given date serial number.
Formula Syntax
Enter in the result column: DAY(column number)
The DAY function syntax has the following argument:
Column number is required. The date you want to find the day for. You should use the DATE function to input dates or input dates as the result of other formulas or functions.
For example, use the function DATE(2023-05-23) to input May 23, 2023. Inputting dates as text may cause issues.
Usage Example
Calculate the day corresponding to the dates in CL2, and write the results into CL3.
CL3 = day(CL2)
The day of September 12, 2023, is 12