Count qty of rows within date range

edited 08/02/22 in Formulas and Functions

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))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!