# No. of Dates between 30, 60 and 90 days from today ...

#### Danni_8oii

##### New Member
Hi Guys.

I'm trying to calculate the number of dates greater than today's date, I've seemed to have managed the >30 Days, however, I'm struggling with the between 30 & 60, and greater than 90 Days...

No. of Dates from Today >30
No. of Dates from Today <30, but less than 60
No. of Dates from Today >90

I've attached an image of the sample data to assist, but would greatly appreciate any support.

#### Attachments

• SampleData.png
41.1 KB · Views: 12

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Alex Blakenburg

##### Well-known Member
Are you sure you don't mean you wanted it aged ?
eg up to 30 days old, 31-60 days old, 61-90 days old, more than 90 days

##### Well-known Member
Hi Danni_8oli,

Does this do what you want?

Danni_8oli.xlsx
ABCDEFG
1Referral Date
29/1/2021>90>60 <=90>30 <=60<=30
39/1/20210007
49/1/2021
59/1/2021
61/1/2020
72/10/2019
85/19/2020
Sheet1
Cell Formulas
RangeFormula
D3D3=COUNTIFS(\$A\$2:\$A\$9999,">"&TODAY()+90)
E3E3=COUNTIFS(\$A\$2:\$A\$9999,">"&TODAY()+60,\$A\$2:\$A\$9999,"<="&G1+90)
F3F3=COUNTIFS(\$A\$2:\$A\$9999,">"&TODAY()+30,\$A\$2:\$A\$9999,"<="&H1+60)
G3G3=COUNTIFS(\$A\$2:\$A\$9999,"<="&TODAY()+30)

#### Alex Blakenburg

##### Well-known Member
Based on your sample dates, I think having it aged is more likely.
If that is correct try this.
Column B is not used in the formulas and is there as visual validation check only.
I also wante to show that the way I have the formula currently is that I have taken >30 to mean exactly that so it that column would start at 31, > 60 would start at 61 etc.

20210908 Date Aging.xlsx
ABCDEFGHI
1Referral DateAging Days (for verification only)As at Date --->8/09/2021
21/09/20217>90>60>300-30Count Total
31/09/20217412310
41/09/20217
51/08/202138
61/07/202169
71/06/202199
810/07/202160
91/09/2020372
1010/02/2019941
1119/05/2019843
12
13count --->10
14
Sheet1
Cell Formulas
RangeFormula
D3D3=COUNTIFS(\$A\$2:\$A\$11,"<"&\$G\$1-90)
E3E3=COUNTIFS(\$A\$2:\$A\$11,"<"&\$G\$1-60,\$A\$2:\$A\$11,">="&\$G\$1-90)
F3F3=COUNTIFS(\$A\$2:\$A\$11,"<"&\$G\$1-30,\$A\$2:\$A\$11,">="&\$G\$1-60)
G3G3=COUNTIFS(\$A\$2:\$A\$11,"<"&\$G\$1-0,\$A\$2:\$A\$11,">="&\$G\$1-30)
H3H3=SUM(D3:G3)
A8A8=G1-60
B2:B11B2=\$G\$1-A2
B13B13=COUNT(B2:B11)

Replies
1
Views
291
Replies
9
Views
290
Replies
5
Views
775
Replies
0
Views
96
Replies
9
Views
373

1,147,482
Messages
5,741,406
Members
423,657
Latest member
Medrok2021

### 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.

### Which adblocker are you using?

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

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