Count rows with 2 date columns where either or both dates past today's date

[John_w]

I have a sheet with dates in two columns: Start Date (column A) and Due Date (column B), rows 2:20. I'm looking for a formula which compares today's date with Start Date and Due Date and if today's date is past either or both of those dates then count that row as 1. The formula should return the total number of rows where today's date is past either the Start Date or the Due Date, or both dates. Either date or both dates on a row may be empty.

Thanks.

 

[Eric W]

Maybe:

=SUMPRODUCT(SIGN((TODAY()>A2:A20)*(A2:A20<>"")+(TODAY()>B2:B20)*(B2:B20<>"")))

 

[John_w]

Thanks Eric, that's perfect.