Countif formula using a date range
deb_63_hydracor
✭✭✭✭✭✭
Hi,
I'm trying to count the number of rows within a specific date range and can't make this formula work:
=COUNTIFS({Date to Deactivate}@row, {Date to Deactivate}@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30))
Thanks for your help!
Tags:
Answers
-
Try these adjustments...
=COUNTIFS({Date to Deactivate}, AND(@cell >= DATE(2022,04,01), @cell <= DATE(2022,04,30))
-
Hi @deb_63_hydracor,
I assume you're capturing the total in a sheet summary field or in a different column. Give this a try:
=COUNTIFS([Date To Deactivate]:[Date To Deactivate], AND(@cell >= DATE(2022, 4, 1), @cell <= DATE(2022, 4, 30)))
I just tried it in a test sheet I created and appears to be working:
I hope that helps!
-
Thanks Paul!
-
Thanks Sing!
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!