IF Function With Date

[AlexG33]

Hello!
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!

[#2]

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

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