Date & Countif Formula

[Rodney Jorgensen]

I have a column of dates in E (Due Dates). I used this formula =COUNTIF(E:E,"="&DATE(2011,3,11)) to determine how many are due on a particular day. This works, now to my question.
In Column G I will be putting a Completed date and I would like a formula to count down the remianing due as I complete them.

So say in E2 I have 3/11/2011 and in G2 I enter 3/7/2011 I want a formula to take the value from the =COUNTIF(E:E,"="&DATE(2011,3,11)) and subtract 1.

Thanks for your help.

 

[T. Valko]

I have a column of dates in E (Due Dates). I used this formula =COUNTIF(E:E,"="&DATE(2011,3,11)) to determine how many are due on a particular day. This works, now to my question.
In Column G I will be putting a Completed date and I would like a formula to count down the remianing due as I complete them.

So say in E2 I have 3/11/2011 and in G2 I enter 3/7/2011 I want a formula to take the value from the =COUNTIF(E:E,"="&DATE(2011,3,11)) and subtract 1.

Thanks for your help.

Let's see if we understand this...

You want to count where column E = some date and the corresponding cell in column G is empty/blank?

What version of Excel are you using?

You can reduce your current formula to:

=COUNTIF(E:E,DATE(2011,3,11))

 

[Rodney Jorgensen]

I'm using 2010.

What is the excel add in so I can post a section of my worksheet in my post?

 

[Rodney Jorgensen]

You want to count where column E = some date and the corresponding cell in column G is empty/blank?

This is correct. Can the formula add it if the cell in column g is "", and if the cell in column G is not "" then do not count it.

 

[T. Valko]

I'm using 2010.

What is the excel add in so I can post a section of my worksheet in my post?

There is a "sticky post" at the top of the page that explains how to do that.

I've never used any of those add-ins so I can't be more specific than that.