Count blank rows

[lapta301]

I have data in column E with no blank entries from E4 to currently E224.
When the job in hand has been done I enter a date in column D.

I would like a formula in D 250 which would find the last row in column E with data in it currently E224 and then count the number of rows in column D that are blank.

I hope this makes sense and as ever your help is appreciated.

EDIT: I should add that the position of the formula will move down as records are added

 

[Fluff]

How about

=LOOKUP(2,1/(E4:E249<>""),ROW(E4:E249))-LOOKUP(2,1/(D4:D249<>""),ROW(D4:D249))

 

[lapta301]

Thank you for your response however it doesn’t appear to be finding any blank rows in column D

 

[Fluff]

I think I may have miss-understood, are you trying to find the number of blanks in col D below the last date, or the total number of blanks?

 

[Habtest]

Is it correct that you'd like the total of rows above 250 where column E is filled but column D is not? Then

=SUM(--ISBLANK(FILTER(D2:D249,LEN(E2:E249)>0)))

 

[Fluff]

Another option for total blanks in D

=COUNTIFS(E$4:E249,"<>",D$4:D249,"")

 

[lapta301]

I think the latest version will work (but what do I know) but the system I’m on at the moment hasn’t been upgraded so I‘ll give it a go on my home machine shortly and report back.
Again sincere thanks for taking the time

 

[lapta301]

Fluff I’m sorry I didn’t realise that there was a new member helping me.
However im pleased to say that they both work fine.

So Fluff and Habest my sincere thanks to you both for taking the time to help me

 

[Fluff]

Glad we could help & thanks for the feedback.