Matching a Date question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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