Due Date Formula Help Needed

[kennethjohnsonjnr]

Hi I am using this formula so that whenever a due date gets close, the field next to it will say "Due date approaching". It works but the problem is "due date approaching" still shows up even if the cell is blank and does not have a due date yet. How can I fix this

=if(c280<TODAY()+,Due Date Approaching")

 

[Joe4]

Your formula is being cut off. You need to put spaces around your greater than/less than signs.
See here: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html\

 

[kennethjohnsonjnr]

=if(c314 < TODAY()+3"Due Date Approaching")

 

[Joe4]

If you want to avoid showing anything if C314 is blank, try this:

[COLOR=#333333]=IF(AND(C314>0,C314 < TODAY()+3),"Due Date Approaching","")[/COLOR]