Hi,

I have my formula for counting the number of cells with a date that falls between certain dates.

=COUNTIFS($K$14:$K$501,">=04/01/20",$K$14:$K$501,"<=04/30/20")

It counts the number of residents whose leases expire between April 1st and April 30th.

I need it to also count how many people renewed their lease if a specific cell contains the text, "renewed" in column L.

So to count the number of cells that say "renewed" between the dates 4/1/20 and 4/30/20.

Hope this makes sense.