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 row 1 of the Sold Date column  

20

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

If row 2 of the In Stock column equals 0, return the number representing the day of the month in row 2 of the Sold Date column. If not return the value In Stock

15

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

Get the sum of the Units Sold column if the Sold Date column returns the day of the month equal to 20. Rows 1 and 3 apply.

295

Still need help? 

Use the Smartsheet Formula Template to view examples and practice working with functions in real-time. 


Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community