COUNTIF formula using a date column - Count number of dates in current month



I am trying to write a formula that allows me to count the number of dates that have the current month. Have tried a few formulas and the only one I can get to work is the following however; I dont get the expected number which should be 4:

=COUNTIFS([Inactive Date]1:[Inactive Date]2232, ISDATE(@cell), [Inactive Date]1:[Inactive Date]2232, MONTH(@cell) = MONTH(TODAY()))

This returns a total of 83 instead of 4:

Note: I did ensure that my Inactive Date column is set to the Date type

Thanks in advance for your help :)

Nick Blocker - Analytics Adventurer


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!