Hi,

With your expiry date in A1 try this

=IF(A1<TODAY()+30,"Warning","")

Mike

"Lynz" wrote:

I have an excel document with dates of when offshore certificates expire. I'd
like a column that would say "Warning" when it's 30 days before the
certificate expires, unitl a new date is entered then it would say "OK".