Hi,

For closer than 30 try
=AND(A1<TODAY()+30,A1=TODAY())

and for overdue
=A1<TODAY()

Mike

"Loc" wrote:

I have a delivery date column with mmm-yy format. How can I write a
conditional formula so that the date turns yellow when it's due in 30 days
and turns red when it's over due? Please help!