IF Function With Date

%3CLINGO-SUB%20id%3D%22lingo-sub-1222233%22%20slang%3D%22en-US%22%3EIF%20Function%20With%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222233%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3CBR%20%2F%3EI%20am%20trying%20to%20create%20an%20IF%20Function%20tracking%20Driver's%20License%20Expirations.%3C%2FP%3E%3CP%3EI%20want%20a%2030%20day%20notice%20to%20pop%20up%20on%20my%20spreadsheet.%3C%2FP%3E%3CP%3EBasically%2C%20if%20the%20DL%20Exp%20Date%20is%20less%20than%2030%20days%20after%20today's%20date%2C%20I%20want%20a%20cell%20to%20format%20as%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIve%20tried%20%3DIF(DL%20DATE%20CELL-TODAY%26lt%3B30%2C%20Y%2C%20N)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20image%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3EThank%20You!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1222233%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222308%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20With%20Date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222308%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579351%22%20target%3D%22_blank%22%3E%40AlexG33%3C%2FA%3E%26nbsp%3BYou%20formula%20contains%20a%20syntax%20error.%20It%20should%20be%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF((D3-TODAY())%26lt%3B30%2C%20Y%2C%20N)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

1 Reply

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

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