Incomplate Online Formula Example - MONTH
Unsure where to post this, but the example is missing an end bracket. See below.
=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
I know it auto appends, but the examples should be updated. Who verifies the validity of the online formula handbook?
Help Article Resources
Check out the Formula Handbook template!