Count dates in range in last X Days

[Drexl88]

Hi,

I have used a Max formula to return the most recent date in the rows in ranges G4:G7, G19:G17, G19:G55, G57:G58, G60:G66 and require a formula to now count how many of the dates in the column G ranges are within the last 60days.

Thanks

 

[mamady]

Hi Dear,

Please try the following:
=COUNTIF(G:G,">"&TODAY()-60)

Adjust range if required

Best Regards

 

[Eric W]

Consider:

Book1
	D	E	F	G
1
2	2	4
3
4				1/1/2020
5				8/1/2020
6				2/2/2020
7				8/10/2020
8
9
10
11
12
13
14
15
16
17				8/11/2020
18				8/25/2020
19				6/9/2020
20
Sheet4

Cell Formulas
Range	Formula
D2	D2	=COUNTIF(G4:G7,">="&TODAY()-60)
E2	E2	=SUM(COUNTIF(OFFSET(G1,{4,17,19,57,60}-1,0,{4,3,37,2,7}),">="&TODAY()-60))

If you want a formula that counts dates in your range for each of your ranges, use the D2 formula. You can 5 similar formulas and add them up to get the grand total, or you can use the E2 formula. The first array constant is the top row of the range, the second array constant is the number of cells in the range.

If there are no other dates in the G column that might affect the results of your formula, then mamady's formula would work.