DAY function - The function returns the date value of a specific date in Excel

The following article introduces you to the DAY function - 1 of the functions in the date and time group function is very popular in Excel.

DAY function - The function returns the date value of a specific date in Excel Picture 1

Description: The function returns date values ​​in specific date, month and year format in Excel.

Syntax: DAY (serial_number)

Where: serial_number is the date value of the date you are looking for.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

For example:

Calculate date values ​​in the following date formats:

DAY function - The function returns the date value of a specific date in Excel Picture 2

- In the cell to calculate enter the formula: = DAY (F7).

DAY function - The function returns the date value of a specific date in Excel Picture 3

- Press Enter -> return value is:

DAY function - The function returns the date value of a specific date in Excel Picture 4

- Similarly copying the formula for the remaining values ​​results:

DAY function - The function returns the date value of a specific date in Excel Picture 5

- Where the day, month, and year values ​​are individual values ​​-> enter the following formula: = DAY (F12 & "/" & G12 & "/" & H12) -> press Enter -> return value is:

DAY function - The function returns the date value of a specific date in Excel Picture 6

Above are instructions and some specific examples when using the DAY function in Excel.

Good luck!