SOLVED
Home

COUNTIF to count cells with dates in them

%3CLINGO-SUB%20id%3D%22lingo-sub-750939%22%20slang%3D%22en-US%22%3ECOUNTIF%20to%20count%20cells%20with%20dates%20in%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750939%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20so%20simple%2C%20but%20I%20can't%20make%20it%20work....%20I%20have%20a%20column%20where%20a%20date%20will%20be%20entered%20for%20some%20cells.%20I%20just%20want%20to%20count%20the%20cells%20with%20dates%20in%20them.%20The%20other%20cells%20will%20be%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20use%20the%20*%20to%20count%20any%20value%20in%20a%20cell%2C%3CSTRONG%3E%3DCOUNTIF(G3%3AG20%2C%22*%22)%3C%2FSTRONG%3Eand%20that%20didn't%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20variation%20that%20will%20count%20date%20values%3F%26nbsp%3B%20The%20column%20in%20question%20is%20formatted%20as%20%22DATE%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750939%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751010%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIF%20to%20count%20cells%20with%20dates%20in%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751010%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374995%22%20target%3D%22_blank%22%3E%40Cheryl4242%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Chery%2C%3C%2FP%3E%3CP%3EYou%20can%20use%20CountA()%20function.%20Please%20refer%20attached%20file.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20196px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123087iB6F4B5A35537F6F5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22CountA1.JPG%22%20title%3D%22CountA1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751014%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIF%20to%20count%20cells%20with%20dates%20in%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%20THANK%20YOU%20SO%20MUCH!%26nbsp%3B%20I%20didn't%20even%20know%20this%20was%20an%20option!%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751063%22%20slang%3D%22en-US%22%3ERe%3A%20COUNTIF%20to%20count%20cells%20with%20dates%20in%20them%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374995%22%20target%3D%22_blank%22%3E%40Cheryl4242%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECOUNTA()%20is%20the%20best%20in%20this%20case%2C%20but%20if%20check%20non-blanks%20with%20COUNTIF%2FCOUNTIFS%20it%20looks%20like%3C%2FP%3E%0A%3CPRE%3E%3DCOUNTIF(G3%3AG20%2C%22%26lt%3B%26gt%3B%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Cheryl4242
New Contributor

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 tried to use the * to count any value in a cell,=COUNTIF(G3:G20,"*") and that didn't work. 

 

Is there some variation that will count date values?  The column in question is formatted as "DATE".

 

Help.

3 Replies
Solution

@Cheryl4242 

 

Hi Chery,

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

Thanks,

Tauqeer

CountA1.JPG

 

@tauqeeracma  THANK YOU SO MUCH!  I didn't even know this was an option!  Thank you!

@Cheryl4242 

COUNTA() is the best in this case, but if check non-blanks with COUNTIF/COUNTIFS it looks like

=COUNTIF(G3:G20,"<>")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies