Google Sheets 함수

DAY

Returns the day of the month for a given date as a number from 1 to 31.

이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.

구문

DAY(serial_number)

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.

serial_number필수The date of the day you are trying to find, represented as a date serial number or a text string.

=DAY("2023-10-15")

결과: 15

Extracts the day from October 15, 2023.

What happens if the date is invalid?

The function will return a #VALUE! error.