Is there a way to match todays date with 2 other data ranges? One is in a
named range on a data sheet and the other in a row on the page. When
comparing the first two, there would only be the possibility of 1 match (I've
been using an array formula for that.

{=SUM(COUNTIF(RangeName,A1:AA1))}

The end result is to populate a cell with a 5 when all three match each
other. I hope this isn't too confusing.

I'm trying to clarify a previous post.