Formula Issue

[Casasas90]

I think this is a pretty simple one for any experts out there but I can't seem to figure out what I'm doing wrong...

=IF(AND("TODAY()>(E2)","=<wbr style="font-family: arial, sans-serif; font-size: small;">ISBLANK(J2)"),"OVERDUE","ON TARGET")

Or in English (I think!) = If the date in Cell E2 is before today's date AND Cell J2 is blank, then the current cell should say OVERDUE, otherwise it should say ON TARGET.

Am I close or is this completely off? Any help would be greatly appreciated!

 

[Matty]

Welcome to MrExcel!

Try:

[FONT=tahoma]=IF(AND(E2[/FONT][FONT=tahoma]< TODAY(),J2=""),"OVERDUE","ON TARGET")[/FONT]

<today(),j2=""),<span style="font-family: arial">Matty
</today(),j2=""),<span>

 

[Casasas90]

Welcome to MrExcel!

Try:

[FONT=tahoma]=IF(AND(E2[/FONT][FONT=tahoma]< TODAY(),J2=""),"OVERDUE","ON TARGET")[/FONT]

<today(),j2=""),<span style="font-family: arial">Matty
</today(),j2=""),<span>

Thanks for the reply Matty. Seems to have done the trick!

Cheers for that pal!

 

[Casasas90]

That worked a treat but unfortunately messed up one of my other formulas:

=IF(TODAY()>(E2),"TODAY()-E2","N/A")

I'm trying to say: If the date in E2 is before today, then the current cell should show the number of days between today and the date in E2, otherwise it should show N/A.

I think I'm missing something simple again but any help would really be appreciated.

 

[ad1234]

[COLOR=#333333]=IF(TODAY()>(E2),"TODAY()-E2","N/A")[/COLOR]

take out the " from round TODAY?

[COLOR=#333333]=IF(TODAY()>(E2),TODAY()-E2,"N/A")[/COLOR]