------ Register to get rid of these "In Post" ads! ------


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())
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/worksheet-functions/151289-solved-match-date-today.html#post549275
> >
> > 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