The DAY function - The function returns the day of the day, month and year in Excel

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!