If your dates are in A1:A100 then you can enter this in A101

=COUNTIF(A1:A100,"" & NOW())/COUNT(A1:A100)
and format as Percentage

"womblew" wrote:

I use a workbook to track training dates for employees. The conditional
formatting and is as follows:

Cond#1 or= =NOW()=31 No background color (shows non-expired dates)

Cond.#2 Between =NOW() and =NOW()=30 Background is YELLOW (shows
30 days to expiration)

Cond.#3 < =NOW() Background is RED (shows expired training dates)


I need a formula at the bottom of the columns that will display the
percentage of non-expired dates (No background)