-
date
- date—The date from which you want to return the day of the month
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.