Buzz
In this article, we present the DAY function, one of the widely used date and time functions in Excel.
Description: This function returns the day value in the specific date format of day, month, and year in Excel.
Syntax: DAY(serial_number)
Where: serial_number represents the date value of the desired date.
Note:
- Excel stores dates in serial number format for convenient calculations.
Example:
Calculate the date value in the following date formats:
- In the cell where you want to calculate, enter the formula: =DAY(F7).
- Press Enter -> the returned value is:
- Similarly, copy the formula for the remaining values to get the results:
- Trường hợp giá trị ngày, tháng, năm là các giá trị riêng rẽ -> nhập công thức sau: =DAY(F12&"/"&G12&"/"&H12) -> nhấn Enter -> giá trị trả về là:
Here is the guide and some specific examples of using the DAY function in Excel.
Wishing you success!
