COUNTIF for dates equal to current month or current week

I'm attempting to create a metric that counts the number of installs in the current month (and also another for those in the current week).

I have tried the following:

=COUNTIF({Master Range 1}, =MONTH(TODAY()))

=COUNTIF({Master Range 1}, =WEEKNUMBER(TODAY()))

I've also tried using SUMIF instead of COUNTIF.

All return "0" even though there are dates that match both criteria.

What am I missing?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!