Matching a Date question

B

ben simpson

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM & OFFSET & PIVOT TABLE?? 0
Drop down list from index/match formula 1
Match/Index/Sum function with date range 2
IF ARRAY with multiple conditions. 1
Index and Match 5
Create if partial match then copy and paste data from one cell to another 1
How to do an IF statement that copy data based on a partial match 0
VBA Filtered Pivot Table Showing "Multiple Values Selected"; Only One Value Selected 0

Top