Hi,

I'm going to guess you mean for the first condition =NOW()+31

If so your formula would be, assuming you dates are in column A:

=COUNTIF(A1:A100,"="&NOW()+31)/COUNT(A1:A100)

format as percent.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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)