womblew wrote:
I have a workbook that lists dates of training qualifications. The individual
cells use a conditional format for expiration, 30 and 60 days before
expiration. at the bottom of each column I would like to display the
percentage of current up to date training.
The conditinal formatting works and is as follows:

Cond. #1 or = =NOW()=31 No bacground color (training is
not expired)

Cond. #2 Between =NOW()=31 and =NOW()=30 Background
Yellow (30 days to expiration)

Cond. #3 < =NOW() Background Red (training expired)


What I need is at the bottom of the column of dates. I need a formula that
will return the percentage of cells that are current. Can it be done and if
so, how?


Suppose your dates are in B2:B52. Use this formula somewhere convenient:

=COUNTIF(B2:B52,"<"&NOW())/COUNT(B2:B52)

or perhaps more accurate if the date = today:

=COUNTIF(B2:B52,"<"&TODAY())/COUNT(B2:B52)