Match date to today
 

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

Match date to today
 

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

=COUNTIF(A:A,TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

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

Match date to today
 

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

Derek

"Jacob Skaria" wrote:

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

=COUNTIF(A:A,TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

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

Match date to today
 

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

"Derek M" wrote:

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

Derek

"Jacob Skaria" wrote:

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

=COUNTIF(A:A,TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

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

Match date to today
 

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
---------------
Jacob Skaria


"Derek M" wrote:

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

"Derek M" wrote:

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

Derek

"Jacob Skaria" wrote:

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

=COUNTIF(A:A,TODAY())

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

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

Match date to today
 

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

"Derek M" wrote:

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