IF Function With Date

Occasional Visitor

I am trying to create an IF Function tracking Driver's License Expirations.

I want a 30 day notice to pop up on my spreadsheet.

Basically, if the DL Exp Date is less than 30 days after today's date, I want a cell to format as red.


Ive tried =IF(DL DATE CELL-TODAY<30, Y, N)


See attached image


Any help would be appreciated.

Thank You!

1 Reply

@AlexG33 You formula contains a syntax error. It should be:

=IF((D3-TODAY())<30, Y, N)