Is it possible to get a count of dates within a 90day period?

I have a list of 225 records.. each or most have a expiration date column.. im trying to build a simple dashboard that can show the user a "count" of records that have a exp date due within 90days of today.

So if only 5 records have a date that is less than 90 away from today, then i just want the dashboard to show that total number..

#1 value 02/20/2025
#2 value 02/21/2023
#3 value 07/25/2022
#4 value 08/14/2022
#5 value 05/21/2022

in the above case, i would want my dash board to show total count of 2 (#3, #4 i dont need to show the rows, just total counts)

then im assuming that with the same formula i can tweak it for the ones that have already passed, and in that case based on this example it would return 1


Dashboard values:

Due to Expire within 90Days = 2
Expired = 1

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

You can use COUNTIFS for that, provided your data is a date in excel sense (not just text which looks like a date). So assuming your dates are in column C:

Formula:

Please Login or Register  to view this content.

shall do. As for already expired COUNTIF shall help

Formula:

Please Login or Register  to view this content.

thanks for the suggestion and help, the first one seems to do exactly what im looking for, had to plug in some dates since that information was not available yet, but counts seem to be calculating correctly.