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

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

if your date is in cell A1, put the following formula in cell B1:

=IF(A1-TODAY()<31,"Warning","OK")

Note that with this formula you'll get "Warning" also when certificates have
already expired. You could improve the process by having:

=IF(A1<TODAY(),"Expired",IF(A1-TODAY()<31,"Warning","OK"))

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

Hi,

You can make a conditional formatting on your date column and find the
result in color for example:
if the date is before expiry date no color
in expiry date the color could be yellow
after expiry date the color could be red

Thanks,
--
Farhad Hodjat


"Idoia" wrote:

if your date is in cell A1, put the following formula in cell B1:

=IF(A1-TODAY()<31,"Warning","OK")

Note that with this formula you'll get "Warning" also when certificates have
already expired. You could improve the process by having:

=IF(A1<TODAY(),"Expired",IF(A1-TODAY()<31,"Warning","OK"))

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