COUNTIF with dates

Hi experts,

I really don't have much time to search for an answer here. Time crunch for my boss!
I'm trying to count a range of dates using COUNTIF. The issue is I'm using dynamic data from two cells with the =TODAY()-30 and =TODAY() functions.

Example: =COUNTIF(DATA,"<B2"), DATA being my named range, I get a 0 in the cell. IF I use =COUNTIF((DATA,"<10/19/2014") I'll get a good count.

I'd also like to count a range of cells with "FIT" in it and cells that do not contain the word "FIT" in them.
Gordon SmithInventory Control CoordinatorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
For your last paragraph,

=COUNTIF(DATA,"*FIT*")

And

=COUNTIF(DATA,"<>*FIT*")
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Instead of =COUNTIF(DATA,"<B2"), use

=COUNTIF(DATA,"<" & B2)
0
 
Gordon SmithInventory Control CoordinatorAuthor Commented:
I've tried the as well Phillip. Same 0 results. Thanks.

For the cells with or without "FIT", that worked, Thank you!
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I think you need to post your spreadsheet.
0
All Courses

From novice to tech pro — start learning today.