DAY Function

Returns a number representing the day of the month, 1-31, where 1 is the first day.
Sample Usage
DAY([Due Date]5)
Syntax
DAY(
  • date
)
  • date
    The date from which you want to return the day of the month.
Examples

This example references the following sheet information:

Row #

Clothing Item

Units Sold

In Stock?

Sold Date

1

T-Shirt

78

true

02/20/19

2

Pants

42

false

02/15/19

3

Jacket

217

true

02/20/19

 

Given the table above, here are some examples of using DAY in a sheet:

Formula

Description

Result

=DAY([Sold Date]1)

Return the number representing the day of the month in the “Sold Date” column row 1. 

20

=IF([In Stock?]2 = 0, DAY([Sold Date]2), "In Stock")

IF the “In Stock” column row 2 equals 0, return the number representing the day of the month in the “Sold Date” column row 2, if not return the value “In Stock”

15

=SUMIF([Sold Date]:[Sold Date], DAY(@cell) = 20, [Units Sold]:[Units Sold])

SUM the “Units Sold” column, IF the “Sold Date” column returns the day of the month equal to 20. Row 1 and 3 apply.

295