Count by Color and Date

[d_tech]

To illustrate the formulas I need I've attached an example of what they should return. Dates are entered into column A. Then the cells get colored grey once they are processed. B2 is supposed to show how many cells are in column A that have a date in them but are not colored. C2 is supposed to show how many cells are in column A that have a recent date (last 3 months or 90 days, doesn't really matter) that are colored in grey.

If someone would help me out that would be appreciated, Thanks!

 

[d_tech]

Ok I've added `=GET.CELL(38,Clients!$A3)` to the name manager in formulas. So then entering the formula by its name `=NumColor` into the B column gives it a value above zero, except line 7 and down remains 0 since there's no background color.

So this part I have down. Now what is the formula to utilize it in B3 and C3 as explained in previous post?

 

[d_tech]

Figured it out by now. Note I wrote B3 and C3 but I meant line 2 as in first post.
B2 is `

=COUNTIFS(A:A,"<"&TODAY(),B:B,0)

C2 is `

=COUNTIFS(A:A,">"&TODAY()-90,B:B,">0")