Matching a Date question

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.

Do you mean

=IF(AND(COUNTIF(RangeName,TODAY())>0,COUNTIF(A1:AA1,TODAY())>0),5,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ben simpson" <bensimpson@discussions.microsoft.com> wrote in message
news:9DB78053-7671-45A9-86D1-12A96AD53BB7@microsoft.com...
> 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.