"Kane" wrote
Success! It works.
Thanks

whew, glad it worked <g
You're welcome !

Another step to the equation....
Issue Date G36
Due Date K36

Certificate is valid to the
1st day of the 25th month of the Issue Date
If renewed within 90 day grace period
prior to expirey/Due date,
ADD 24 months to the original Issue date.
If beyond the Due Date,"Expired"

Try in K36:

=IF(G36="","",IF(G36<TODAY()-90,"Expired",IF(AND(G36<TODAY(),G36=TODAY()-90
),DATE(YEAR(G36+365*2),MONTH(G36+365*2)+1,1),"Not due yet")))

(above formula is all in one line,
you'd need to restore the line breaks/wraps
after copy pasting into the formula bar)

I would like both a 2 month conditional format
"Red" font warning, and
"Red"font for "Expired"... is this possible?
... Wayne

Try this

Select G36
Click Format Conditional Formatting
Make the settings under Condition 1 as:
Formula Is | =G36<=TODAY()-60
Click Format button Font tab Red & bold OK
Click OK at the main dialog

Repeat steps for K36, except change:
Formula Is | =K36="Expired"

--

These are some test sample dates in G36
and results in K36 with the constructs above effected
(dates in format: mm-dd-yy)

If in G36: 09/20/04 (date will be in red and bolded)
K36 will show: Expired (in red and bolded)

If in G36: 10/20/04 (date will be in red and bolded)
K36 will show: 11/01/06 (no font formatting - normal)

If in G36: 11/20/04 (no font formatting - normal)
K36 will show: 12/01/06 (no font formatting - normal)

If in G36: 12/20/04 (no font formatting - normal)
K36 will show: 01/01/07 (no font formatting - normal)

If in G36: 01/20/05 (no font formatting - normal)
K36 will show: Not due yet (no font formatting - normal)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----