Not sure what to use...sumif, countif, sumproduct

[dgardnerman]

Hi group,

I've been digging for hours trying to figure out what to use for this formula and I am coming up with blanks...
I want to count the dates in column A that will come due in 1 week, 2 weeks, 3 weeks, etc and report that number back to the corresponding cell A1,A2,A3,A4 or A5, yes each will have a different formula based on the due criteria. I think I'm close, I just not sure if I am expressing the ">=" values correctly.

Also, I need to make sure it'll work if there are blanks found in the range of A21:A175

Thanks for your help!

 

[dgardnerman]

I think I figured it out....I'm using this:
=COUNTIFS($A$21:$A$175,">="&TODAY(),$A$21:$A$175,"<="&TODAY()+7) ------this watches anything within week 1
=COUNTIFS($A$21:$A$175,">="&TODAY()+7,$A$21:$A$175,"<="&TODAY()+14) --this watches anything within week 2

It appears to be doing what I want and the blanks do not appear to be an issue

 

[Toadstool]

I'd suggest changing the "<=" to "<" otherwise you'll count the TODAY()+7 twice.

Book1
	A	B	C	D
1	Updated	11/20/2019
2
3
4
5	Due in 1 week	2
6	Due in 2 weeks	1
7	Due in 3 weeks	2
8	Due in 4 weeks	2
9	Past Due	1
10
19
20	Due Date	Submitted Final Rev.	Rev.	Estimate No.
21	11/19/2019	11/18/2019	2	737373
22	11/21/2019	11/22/2019	-	368687
23	11/22/2019	11/26/2019	-	184343
24	11/30/2019	11/30/2019	4	727271
25	12/5/2019	12/4/2019	2	929292
26	12/8/2019	12/8/2019	-	8383838
27	12/12/2019	12/12/2019	-	4191919
28	12/16/2019	12/16/2019	4	2095960
29	12/20/2019	12/20/2019	2	1047980
30	12/24/2019	12/24/2019	-	523990
31	12/26/2019	12/26/2019	-	261995
Sheet1

Cell Formulas
Range	Formula
B1	B1	=TODAY()
B5	B5	=COUNTIFS($A$21:$A$75,">="&$B$1+0,$A$21:$A$75,"<"&$B$1+7)
B6	B6	=COUNTIFS($A$21:$A$75,">="&$B$1+7,$A$21:$A$75,"<"&$B$1+14)
B7	B7	=COUNTIFS($A$21:$A$75,">="&$B$1+14,$A$21:$A$75,"<"&$B$1+21)
B8	B8	=COUNTIFS($A$21:$A$75,">="&$B$1+21,$A$21:$A$75,"<"&$B$1+28)
B9	B9	=COUNTIFS($A$21:$A$75,"<"&$B$1)

 

[dgardnerman]

Thank you, I did exactly that before your response and it worked great...