Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Counting current months in a date column
I am trying to get a count of due dates in the current month, here is the formula I am using and it always returns zero. the formula is in a text/number column and the data is in a date column.
=COUNTIF([Due Date]3:[Due Date]204, MONTH(TODAY()))
I,m a beginner and could really use the help. not getting errors, just a zero and there are dates in the column with the current month.