Forum Discussion
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...
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.
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
