Countifs from another smartsheet using a date range

PStewart

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!

jmyzk_cloudsmart_jp

Hi @PStewart

Try these;😀

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

or

=COUNTIF({CAR Log Range 1}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31)))

jmyzk_cloudsmart_jp

Hi @PStewart

Try these;😀

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

or

=COUNTIF({CAR Log Range 1}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31)))

PStewart

The second formula worked great!! thank you

jmyzk_cloudsmart_jp

Happy to help!😁