COUNTIF with dates
Posted on 2014-11-18
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.