-
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 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 |