Countif/Sum adding 2 dates

Options

I am trying to count how many leases are signed between two dates (i.e 1/1/2024 to 3/31/2024). This is the formula I am using

=COUNTIFS({STORE WORKING FILE Range 1}, >=DATE(1 / 1 / 2024), {STORE WORKING FILE Range 1}, <=DATE(3 / 31 / 2024))

Store working file Range 1 = Lease Signed Date

I am getting an incorrect argument. Any thoughts

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!