Trying to measure compliance on expiry dates for training

Hi all,
I have a file I want to add some formulas to, that I "think" may be countif. The first formula is to return a compliance level in D5 by adding all the cells within a range with a date greater than today or NA - but anything less than today, or a blank cell it ignores.
The formulas are (I think) in

 =COUNTIF(G8:AW15,"<"&TODAY())

but can't quite finish it.
On the Compliance worksheet, this is where I really got lost!
I have a chart I want to populate based on the dates in the cells in the Current worksheet, but using a criteria of the conditional formatting within the date range of cells (3 rules), and return three values. 1 of anything within 30 days, 1 of anything within 90 days, and 1 of anything within 365 days.

Any help would be appreciated please.