Countifs from another smartsheet using a date range

I have tried 2 different formulas, and neither one matches the data which was previously on an excel spreadsheet:

=COUNTIFS(CAR Log Range 1}, ">=01-JAN-2022", {CAR Log Range 1}, "<=31-JAN-2022")

I get a value of 2, which should be 1 as per my excel spreadsheet

=COUNTIFS(Date:Date, {CAR Log Range 1} >= DATE(2022, 1, 1), Date:Date, {CAR Log Range 1}l <= DATE(2022, 1, 31))

And this one just gets an error

Help is appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!