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:

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

In the cell to calculate enter the formula: DAY (C7) .

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

Press Enter -> separated date value results:

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

Copying the formula for the remaining values ​​results in:

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

If, if the month does not have 31 days, you still enter a date containing 31 days -> the function returns the # VALUE error value ! .

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

Above is the usage and some notes when using the DAY function in Excel.

Good luck!