# Formula Issue

#### Casasas90

##### New Member
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!

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Welcome to MrExcel!

Try:

Code:
``[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>

Last edited:
Welcome to MrExcel!

Try:

Code:
``[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!

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.

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

take out the " from round TODAY?

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

Replies
3
Views
166
Replies
6
Views
370
Replies
6
Views
414
Replies
1
Views
413
Replies
1
Views
336

1,202,990
Messages
6,052,961
Members
444,621
Latest member
MIKOLAJ_R

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back