Match date to today

  • Thread starter Thread starter Derek M
  • Start date Start date
D

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
 
If the dates in ColA are in excel date format the below would work...

=COUNTIF(A:A,TODAY())

If this post helps click Yes
 
I think you have helped me before, and it worked again, thank you so much,
you are a genuis :)

Derek
 
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
 
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
 
Thanks for your help again, i veru much appreciate it, i am learning all the
time too
 
Back
Top