I need to create a formula that counts the number of times there is an overdue date in column I, where the corresponding cell in column J is blank.

I enter a date in column H (date appointed). There is a formula to auto-fill column I (date due) which is:

```
=IF(ISBLANK(H6), " ", EDATE(H6,6))
```

I need to create a formula to count the number of dates in column I which are older than today but only if the corresponding cell in column J is blank.

I have tried:

```
=COUNTIFS(I6:I260,"<TODAY()",J6:J260,"<>"&"""")
```

but I suspect it is counting the auto-fill formula in column I.

`J`

is blank, or where it isn’t? – Scott Feb 19 '19 at 5:22