The following article details how to use the DAY function, the function returns the day of the day, month and year in Excel.
Description: The function takes a date value from a date value. The return value is an integer between 1 and 31.
Syntax: DAY (serial_number) .
Inside:
serial_number is the date value that you want to extract the date value.
For example:
Separate date values from the following dates:
In the cell to calculate enter the formula: DAY (C7) .
Press Enter -> separated date value results:
Copying the formula for the remaining values results in:
If, if the month does not have 31 days, you still enter a date containing 31 days -> the function returns the # VALUE error value ! .
Above is the usage and some notes when using the DAY function in Excel.
Good luck!