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