Forum Discussion

Copper Contributor

Jul 11, 2019

Solved

COUNTIF to count cells with dates in them

It's so simple, but I can't make it work.... I have a column where a date will be entered for some cells. I just want to count the cells with dates in them. The other cells will be blank. I've tr...

Formulas and Functions

tauqeeracma
Jul 11, 2019
Cheryl4242

Hi Chery,
You can use CountA() function. Please refer attached file.
Thanks,
Tauqeer

CountA.xlsx8 KB

Steel Contributor

Jul 11, 2019

Hi Chery,

You can use CountA() function. Please refer attached file.

Thanks,

Tauqeer

CountA.xlsx8 KB

RRoux
Copper Contributor
Jul 04, 2023
tauqeeracma Hello, I wanted to count say how many appointments someone had in a given month so trying =COUNTIF('Appointments’!O4:O2974,"=">"01/07/2023,<31/07/2023") I'm using the format the dates are in that range. It's returning 1 when there are many more there? Any help appreciated thanks.
- tauqeeracma
  Steel Contributor
  Jul 04, 2023
  Hi RRoux
  
  You can use COUNTIFS() function to achieve your requirements. Please refer to the attached sample file for more understanding.
  
  Hope it will help you.
  
  Thanks
  Tauqeer
  Appointment Count.xlsx9 KB
  - beigemc
    Copper Contributor
    Dec 06, 2023
    tauqeeracma
    
    How do you count the cells with just dates on them?
Johnny557
Copper Contributor
Jun 05, 2022
tauqeeracma This was a great help to me also.

Thank you,

Johnn557.
Cheryl4242
Copper Contributor
Jul 11, 2019
tauqeeracma THANK YOU SO MUCH! I didn't even know this was an option! Thank you!
- SergeiBaklan
  MVP
  Jul 11, 2019
  Cheryl4242
  
  COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like
  
  =COUNTIF(G3:G20,"<>")
  - MIDE_001
    Copper Contributor
    Jul 07, 2021
    This was really helpful...thank you
    SergeiBaklan

Resources