Countif/Sum adding 2 dates

Patti2023

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

DKazatsky2

Hi @Patti2023,

Your syntax for the DATE function is incorrect. The syntax is DATE(year, month, day).

Hope this helps,

Dave

Patti2023

THANK YOU!!!!