IF / OR Formula Confusion

[Logit]

Trying to write a formula for:

If A3 is BLANK, Then B3 is Blank, Else (if the date in A3 is within 30 days of TODAY) then B3 will display "30 Day Alert", otherwise B3 will be Blank.

This is what I have so far:

Please Login or Register  to view this content.

Presently A3 does not have anything written in it, yet with the above formula the "30 Day Alert" notice still displays. The only thing I've done with A3 is format it for a specific DATE display.

Please help.

[Logit]

I apologize for the confusion. Since posting my original request I have solved my own challenge.

Please Login or Register  to view this content.

Thank you for reading.

Cheers !

[FDibbins]

No real need to use ISBLANK, you could also do it this way...
=IF(A3="","",IF(A3<(TODAY()+30),"30 DAY ALERT",""))

[Logit]

Thank you. I tried a formula *close* to that but didn't quite have it right.

I'll add your formula to my toolbox.

Thank you !

[FDibbins]

Cool, thanks for the feedback