DAY Function in Google Sheets

Extracts the day of the month from a date value.

DAY Function

The DAY function extracts the day of the month from a date value.

Syntax

DAY(date)
  • date: The date value from which the day is extracted.

Examples

  1. Basic Example

Extract the day from the date August 14, 2024:

=DAY(DATE(2024, 8, 14))
  1. From a Cell

Extract the day from a date in cell A1:

=DAY(A1)

Notes

  • This function is useful for breaking down date values into individual components.
  • MONTH: Extracts the month from a date value.