Home Application Office information

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

The DAY function: The function returns a date value in a specific date, month, and year format in Excel. Syntax: DAY (serial_number)

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.

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

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:

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

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

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

- Press Enter -> return value is:

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

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

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

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

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

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

Good luck!

You've just finished reading the article "DAY function - The function returns the date value of a specific date in Excel" edited by the TipsMake team. You can save day-function-the-function-returns-the-date-value-of-a-specific-date-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV The DAYS function - The function returns the number of days between 2 dates in Excel
NEXT » DATEVALUE function - Functions to convert text format dates to serial numbers in Excel
Read more