Countif formula for dates

Oakey

New Member
Joined
Jan 9, 2017
Messages
47
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

09/03/2019
09/02/2019
23/02/2019
26/02/2019
26/02/2019
27/02/2019
02/03/2019
07/03/2019
11/03/2019
11/03/2019
11/03/2019
11/03/2019
11/03/2019
11/03/2019
14/03/2019
14/03/2019
15/03/2019
15/03/2019
15/03/2019
15/03/2019
16/03/2019
16/03/2019
16/03/2019
16/03/2019
16/03/2019
16/03/2019

<colgroup><col></colgroup><tbody>
</tbody>
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
i want a formula that will count the dates that are older than the 10 days.

Hi, something like..


Excel 2013/2016
ABCD
109/03/201925
209/02/201928/05/201925
323/02/2019
426/02/2019
526/02/2019
627/02/2019
702/03/2019
807/03/2019
911/03/2019
1011/03/2019
1107/06/2019
1211/03/2019
1328/05/2019
1411/03/2019
1514/03/2019
1614/03/2019
1715/03/2019
1815/03/2019
1915/03/2019
2015/03/2019
2116/03/2019
2216/03/2019
2316/03/2019
2416/03/2019
2516/03/2019
2616/03/2019
Sheet1
Cell Formulas
RangeFormula
D1=COUNTIFS(A:A,"<="&TODAY()-10)
D2=COUNTIFS(A:A,"<="&C2)
 
Upvote 0

Forum statistics

Threads
1,214,656
Messages
6,120,762
Members
448,991
Latest member
Hanakoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top