Generate Due Date Alert Problem

[Jingaud]

[FONT=&quot]Good Day All,[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I have been trying to activate an alert date on excel. I am using Excel 2013. Here is the function I have inserted:[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]=IF(G719<(TODAY()+1),”DUE”,” “)[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I don’t understand why it is showing as ‘Due’ when my Due Date for Next action plan is empty.

Is there something wrong with the function I have entered in?[/FONT]

 

[Yongle]

If G719 is empty, then it satisfies your condition, because EMPTY CELL is always less than TODAY()+1

Try adding a second condition...
<today()+1,g719><today()+1,g719>
=</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>IF(</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>AND(</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>G719>0</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>,</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>G719>TODAY()+1</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>)</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>,</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>"DUE","")</today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719></today()+1,g719></today()+1,g719><today()+1,g719><today()+1,g719>
</today()+1,g719></today()+1,g719>

 

[Jingaud]

Hi Yongle,

Thanks for the input and the very prompt response.

I have tried putting in the second condition, but now the 'Due' will not activate no matter what. I have attached an image below:

[/URL][/IMG]

Thank you so much for the help thus far. Much appreciated.

 

[Fluff]

There's a typo in Yongle formulae, try
=IF(AND(G719>0,G719 < TODAY()+1),"DUE","")

EDIT
Corrected formula. Board stripped part of it out because of < sign

 

[Yongle]

@Fluff Thanks for the input, but my formula is as intended - it may not do the required job but it is what I typed
@Jingaud - in which cell did you put the formula?

Your formula
=IF(G719<(TODAY()+1),”DUE”,” “) was presumably in cell F719

My formula
as provided in post2 is a direct replacement for that and should have been put in F719

Same formula place in F2 and copy down
=IF(AND(G2>0,G2>TODAY()+1),"DUE","")

<tbody>
[TD="class: xl68, align: right"] 1
[/TD]
[TD="width: 30"][/TD]
[TD="width: 5"][/TD]
[TD="class: xl65, width: 275"]FORMULA[/TD]
[TD="class: xl66, width: 64"]Warning[/TD]
[TD="class: xl65, width: 75"]Date[/TD]

[TD="class: xl68, align: right"] 2
[/TD]

[TD="class: xl65"]=IF(AND( G2 >0, G2 >TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]23/04/2018[/TD]

[TD="class: xl68, align: right"] 3
[/TD]

[TD="class: xl65"]=IF(AND(G3>0,G3>TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"][/TD]
[TD="class: xl67"]24/04/2018[/TD]

[TD="class: xl68, align: right"] 4
[/TD]

[TD="class: xl65"]=IF(AND(G4>0,G4>TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"]DUE[/TD]
[TD="class: xl67"]25/04/2018[/TD]

[TD="class: xl68, align: right"] 5
[/TD]

[TD="class: xl65"]=IF(AND(G5>0,G5>TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"]DUE[/TD]
[TD="class: xl67"]26/04/2018[/TD]

[TD="class: xl68, align: right"] 6
[/TD]

[TD="class: xl65"]=IF(AND(G6>0,G6>TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"]DUE[/TD]
[TD="class: xl67"]27/04/2018[/TD]

[TD="class: xl68, align: right"] 7
[/TD]

[TD="class: xl65"]=IF(AND(G7>0,G7>TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"]DUE[/TD]
[TD="class: xl67"]28/04/2018[/TD]

[TD="class: xl68, align: right"] 8
[/TD]

[TD="class: xl65"]=IF(AND(G8>0,G8>TODAY()+1),"DUE","")[/TD]
[TD="class: xl66"]DUE[/TD]
[TD="class: xl67"]29/04/2018[/TD]

</tbody>

 

[Fluff]

@Fluff Thanks for the input, but my formula is as intended - it may not do the required job but it is what I typed

My "Corrected" was modified by the board software because of the < sign, which I have now corrected, in post#4
The Op's formula was if G < Today+1, but you are still saying if G > Today+1
Which I suspect is why it's not working for the OP

 

[Yongle]

@Fluff - that explains everything. I was looking at half a formula in your post! I did not spot the "<" error. You were indeed correct. Thanks for the catch.
Why does the board software eat our formula?

 

[Fluff]

It sees < as HTML code & therefore treats is as such.
You need to either place the formula in a code window (which I think works), or put a space before & after the < sign

 

[Jingaud]

Thank you Yongle and Fluff for your help. It really helped me as a newcomer to excel. Very much appreciated.