Count qty of rows within date range

mgproudfit

Hello, all -

I am putting together a dashboard for my company's RE needs and am wanting to summarize the qty of leases that expire within a given year. I currently have date columns setup for Lease State and Lease End with D,M,Y. We have over 100 locations and I want to create a summary field that pulls out QTY of 2022 Lease Expirations, 2023 Lease Expirations, etc. etc. but can't seem to get a formula that works. Any help would be appreciated!

This is where Im at so far:

=COUNTIFS(Lease End:Lease End,>=date(2022,01,01),<=date(2022,12,31))

Thanks!

Heather_Verde

Try calling your range again for the end date to see if that helps.

=COUNTIFS([Lease End]:[Lease End],>=date(2022,01,01), [Lease End]:[Lease End],<=date(2022,12,31))