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","")

1			FORMULA	Warning	Date
2			=IF(AND(G2>0,G2>TODAY()+1),"DUE","")		23/04/2018
3			=IF(AND(G3>0,G3>TODAY()+1),"DUE","")		24/04/2018
4			=IF(AND(G4>0,G4>TODAY()+1),"DUE","")	DUE	25/04/2018
5			=IF(AND(G5>0,G5>TODAY()+1),"DUE","")	DUE	26/04/2018
6			=IF(AND(G6>0,G6>TODAY()+1),"DUE","")	DUE	27/04/2018
7			=IF(AND(G7>0,G7>TODAY()+1),"DUE","")	DUE	28/04/2018
8			=IF(AND(G8>0,G8>TODAY()+1),"DUE","")	DUE	29/04/2018

<tbody>
</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.