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 Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.