Solved

COUNTIF with dates

Posted on 2014-11-18
4
99 Views
Last Modified: 2014-12-03
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.
0
Comment
Question by:smidy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40450820
Instead of =COUNTIF(DATA,"<B2"), use

=COUNTIF(DATA,"<" & B2)
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40450832
For your last paragraph,

=COUNTIF(DATA,"*FIT*")

And

=COUNTIF(DATA,"<>*FIT*")
0
 

Author Comment

by:smidy
ID: 40450833
I've tried the as well Phillip. Same 0 results. Thanks.

For the cells with or without "FIT", that worked, Thank you!
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40450839
I think you need to post your spreadsheet.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
Viewers will learn how to find and create templates in Excel 2013.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question