Returns the day of the month for a given date as a number from 1 to 31.
ไวยากรณ์
DAY(serial_number)อาร์กิวเมนต์
serial_numberจำเป็น
The date of the day you are trying to find, represented as a date serial number or a text string.
The DAY function extracts the day component from a date value. The result is an integer representing the day of the month, ranging from 1 to 31.
=DAY("2023-10-15")→15Extracts the day from October 15, 2023.
Select a cell
Click on the cell where you want to display the day.
Enter the formula
Type =DAY(date) and press Enter.
The function will return a #VALUE! error.