IF Function With Date

Question

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.&nbsp;Ive tried =IF(DL DATE CELL-TODAY&lt;30, Y, N)&nbsp;See attached image&nbsp;Any help would be appreciated.Thank You!

riny_van_eekelen · Answer

AlexG33&nbsp;You formula contains a syntax error. It should be:=IF((D3-TODAY())&lt;30, Y, N)&nbsp;

Forum Discussion

IF Function With Date

1 Reply

Resources