# Days Past Due remain blank

#### krisking64

##### New Member
I'm hoping you can help.

PO Date is F2, Due Date is G2, and Received Date is I2.

I currenty have =IF(ISBLANK(I2),TODAY()-G2,I2-G2) as my formula in H2 so it will stop counting once I enter a received date. However, I do not want to a negative number in H2 if the due date has not arrived yet. I had =IF(DAYS360(G2,TODAY())<1,"",DAYS360(G2,TODAY())) in H2. This formula would leave a blank in H2 if the due date had not been met but it would not stop counting.

What is the best way to resolve this issue?

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Marcílio_Lobão

##### Well-known Member
krisking64, Good afternoon.

Try to use:

=IF(G2="", "", IF(ISBLANK(I2), TODAY()-G2, I2-G2))

Is that what you want?
I hope it helps.

#### krisking64

##### New Member

The formula you provided did not make a difference. I still have a negative number in H2.

#### krisking64

##### New Member
I found the issue,

=IF(I2="", "", IF(ISBLANK(I2), TODAY()-G2, I2-G2))

Replies
14
Views
683
Replies
9
Views
1K
Replies
9
Views
403
Replies
0
Views
593
Replies
3
Views
1K

1,191,280
Messages
5,985,731
Members
439,978
Latest member
Mr930R

### 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