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

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

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

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

It would be a subtraction

=today()-A3


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=151289

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]