Help!! ** How to use Countif to count dates that occur today and before?

%3CLINGO-SUB%20id%3D%22lingo-sub-1317874%22%20slang%3D%22en-US%22%3EHelp!!%20**%20How%20to%20use%20Countif%20to%20count%20dates%20that%20occur%20today%20and%20before%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317874%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20Help%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20count%20the%20amount%20of%20dates%20in%20a%20column%20that%20occur%20today%20and%20then%20also%20count%20the%20amount%20between%20today%20and%20in%20the%20past%20by%20number%20of%20days%20(not%20date).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMike%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1317874%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-1317882%22%20slang%3D%22en-US%22%3ERe%3A%20Help!!%20**%20How%20to%20use%20Countif%20to%20count%20dates%20that%20occur%20today%20and%20before%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317882%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F627303%22%20target%3D%22_blank%22%3E%40mikeuk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMike%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DCOUNTIF(A%3AA%2CTODAY())%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DCOUNTIFS(A%3AA%2C%22%26lt%3B%22%26amp%3BTODAY()%2CA%3AA%2C%22%26gt%3B%3D%22%26amp%3B(TODAY()-30))%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1317892%22%20slang%3D%22en-US%22%3ERe%3A%20Help!!%20**%20How%20to%20use%20Countif%20to%20count%20dates%20that%20occur%20today%20and%20before%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1317892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Sergei%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20used%20the%20first%20one%20and%20it%20works%20perfectly!%20thank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20I%20need%20the%20second%20one%20to%20display%20the%20amounts%20of%20dates%20in%20total%20that%20occur%20before%20today%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi All, 

 

Please Help, 

 

I need to be able to count the amount of dates in a column that occur today and then also count the amount between today and in the past by number of days (not date).

 

Can you help?

 

Thank you in advance

 

Mike 

3 Replies
Highlighted

@mikeuk 

Mike,

 

That's like

=COUNTIF(A:A,TODAY())

and

=COUNTIFS(A:A,"<"&TODAY(),A:A,">="&(TODAY()-30))
Highlighted

@Sergei Baklan 

 

Hi Sergei, 

 

Thank you so much for your help!

 

I have used the first one and it works perfectly! thank you

 

But, I need the second one to display the amounts of dates in total that occur before today? 

 

Thanks

 

Mike

Highlighted

@mikeuk 

Mike, if before today

=COUNTIFS(A:A,"<"&TODAY())

 or you need number of dates, not number of records? For example, if today is Apr 18, and you have 3 records for Apr 16 and two records for Apr 17, above formula returns 5. If calculate only dates it shall be 2, please clarify what is required.