-
date
-
date—The date from which you want to return the month
This example references the following sheet information:
Row # |
销售日期 |
Transaction Total |
Item Number |
Clothing Item |
|---|---|---|---|---|
1 |
02/12/19 |
$1,170.00 |
C001 |
t恤 |
2 |
02/15/19 |
$1,491.00 |
C002 |
Pants |
3 |
02/20/19 |
$812.00 |
C003 |
Jacket |
4 *Leave blank |
Given the table above, here are some examples of using a MONTH() function in a sheet:
Formula |
Description |
Result |
|---|---|---|
=MONTH([Sold Date]1) |
Returns the representing month number for row 1 in the销售日期column (February) |
2 |
=SUMIF([Sold Date]1:[Sold Date]3, MONTH(@cell) = 2, [Transaction Total]1:[Transaction Total]3) |
Sums the values in theTransaction Totalcolumn if the value in the销售日期column return a month value equal to2. Rows 1, 2, and 3 meet the criteria. |
$3473 |
=COUNTIF([Sold Date]:[Sold Date], MONTH(@cell) = 2) |
When the MONTH function contains a blank cell within the range of dates it is reviewing, it will produce the #INVALID DATA TYPE error. This is expected behavior. To resolve this, you’ll want to utilize an IFERROR function. |
#INVALID DATA TYPE |
=COUNTIF([Sold Date]:[Sold Date], IFERROR(MONTH(@cell), 0) = 2) |
By wrapping the MONTH function in an IFERROR function, the function will no longer produce an error. This formula counts the number of values in the销售日期column that are equal to2(February). |
3 |
Still need help?
Use theFormula Handbook templateto 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.