Match date to today

[Derek M]

Hi All

need to match dates in a column of data to todays date, i.e.

3/11/09
4/11/09
5/11/09
5/11/09

If today is 5/11/09 then the cell would return the value 2, i cant figure
out the sum

Thanks for any help in advance

Derek

 

[Jacob Skaria]

If the dates in ColA are in excel date format the below would work...

=COUNTIF(A:A,TODAY())

If this post helps click Yes

 

[joel]

It would be a subtraction

=today()-A

 

[Derek M]

I think you have helped me before, and it worked again, thank you so much,
you are a genuis

Derek

 

[Derek M]

Ooh just one other thing if i may, what if i also wanted to reference another
column to filter out just one word i.e. match the date to today, but also
check another column for the word "mymail" and bring just those results back
(count mymail under todays date)

Thanks again

Derek

 

[Jacob Skaria]

When you have multiple criteria use SUMPRODUCT()

=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2))
=SUMPRODUCT((A1:A10=TODAY())*(B1:B10="mymail"))

If you are using XL2007; check out help on COUNTIFS()

If this post helps click Yes

 

[Derek M]

Thanks for your help again, i veru much appreciate it, i am learning all the
time too