Counting dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2146543%22%20slang%3D%22en-US%22%3ECounting%20dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2146543%22%20slang%3D%22en-US%22%3E%3CP%3Etrying%20to%20get%20a%20sum%20at%20the%20bottom%20of%20the%20active%20order%20tab%20that%20counts%20the%20%23%20of%20orders%20in%20a%20certain%20date%20range%20i%20how%20many%20are%20past%20due%20or%20due%20today%20or%20due%20in%20the%20week%3C%2FP%3E%3CP%3Eand%20the%20Countif%20isn't%20working%20for%20me%20any%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2146543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

trying to get a sum at the bottom of the active order tab that counts the # of orders in a certain date range i how many are past due or due today or due in the week

and the Countif isn't working for me any help?

1 Reply

@Mary80921 

Since you have two boundaries for the range, COUNTIFS() shall be used. For example, for Past Due

 

=COUNTIFS(H2:$H$47, ">=" & TODAY()-7, $H$2:$H$47, "<" & TODAY())