Countif formula for dates

[Oakey]

Whats the formula i need to type to do a count of dates that are less than a fixed date?

Ie if i have todays date (=today()) as my formula and then do a separate formula to get the date that was 10 days ago, i want a formula that will count the dates that are older than the 10 days.

Hope that makes sense

[TABLE="width: 142"]
<colgroup><col></colgroup><tbody>[TR]
[TD]09/03/2019[/TD]
[/TR]
[TR]
[TD]09/02/2019[/TD]
[/TR]
[TR]
[TD]23/02/2019[/TD]
[/TR]
[TR]
[TD]26/02/2019[/TD]
[/TR]
[TR]
[TD]26/02/2019[/TD]
[/TR]
[TR]
[TD]27/02/2019[/TD]
[/TR]
[TR]
[TD]02/03/2019[/TD]
[/TR]
[TR]
[TD]07/03/2019[/TD]
[/TR]
[TR]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]11/03/2019[/TD]
[/TR]
[TR]
[TD]14/03/2019[/TD]
[/TR]
[TR]
[TD]14/03/2019[/TD]
[/TR]
[TR]
[TD]15/03/2019[/TD]
[/TR]
[TR]
[TD]15/03/2019[/TD]
[/TR]
[TR]
[TD]15/03/2019[/TD]
[/TR]
[TR]
[TD]15/03/2019[/TD]
[/TR]
[TR]
[TD]16/03/2019[/TD]
[/TR]
[TR]
[TD]16/03/2019[/TD]
[/TR]
[TR]
[TD]16/03/2019[/TD]
[/TR]
[TR]
[TD]16/03/2019[/TD]
[/TR]
[TR]
[TD]16/03/2019[/TD]
[/TR]
[TR]
[TD]16/03/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

i want a formula that will count the dates that are older than the 10 days.

Hi, something like..

Excel 2013/2016
	A	B	C	D
1	09/03/2019			25
2	09/02/2019		28/05/2019	25
3	23/02/2019
4	26/02/2019
5	26/02/2019
6	27/02/2019
7	02/03/2019
8	07/03/2019
9	11/03/2019
10	11/03/2019
11	07/06/2019
12	11/03/2019
13	28/05/2019
14	11/03/2019
15	14/03/2019
16	14/03/2019
17	15/03/2019
18	15/03/2019
19	15/03/2019
20	15/03/2019
21	16/03/2019
22	16/03/2019
23	16/03/2019
24	16/03/2019
25	16/03/2019
26	16/03/2019
Sheet1

Cell Formulas
Range	Formula
D1	=COUNTIFS(A:A,"<="&TODAY()-10)
D2	=COUNTIFS(A:A,"<="&C2)

 

[Oakey]

Thank you that worked perfectly