DAY pitfall 1: Returns the day-of-month (1-31)?

Returns the day-of-month (1-31). For day-of-year use `DAYS(date, DATE(YEAR(date), 1, 1)) + 1`.

DAY pitfall 2: Like MONTH and YEAR, depends on the cell being a real date or a parseable string?

Like `MONTH` and `YEAR`, depends on the cell being a real date or a parseable string.

Dateeasy

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

Syntax

=DAY(date)

Arguments

Argument	Description
date	The date to query.

Example

=DAY("2026-05-07")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and DAY isn't one of them yet.

Returns the day-of-month (1-31). For day-of-year use DAYS(date, DATE(YEAR(date), 1, 1)) + 1.
Like MONTH and YEAR, depends on the cell being a real date or a parseable string.

Related formulas

Used by