Table of Contents
Summary
The Excel DAY function returns the day of the month, a number between 1 and 31. The DAY function is an Excel date and time function.
Function
=DAY(serial_number)
Arguments (inputs)
serial_number = a number representing a date in Microsoft Excel
Return value
The DAY function returns the day of the month, a number between 1 and 31.
Example
In the example above the DAY function returns the day of the month for the date in cell C5.
=DAY(C5)
The result returned is 20.
