日付と時刻

Excel DAY 関数

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.

DAY関数の機能

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")→15

Extracts 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.

What happens if the date is invalid?

The function will return a #VALUE! error.