Using DCOUNT to compare date columns?

[stuart_fort]

I am wanting to count the number of instances where the date in Column B is at least 5 days after the date in Column A, provided Column A is not blank. I cannot seem to structure the DCOUNTA formula to do this.

Column A Column B
Arrive Date Need By Date
04/14/11 05/07/11
04/12/11 04/06/11
04/01/11 04/15/11
03/31/11 04/28/11
03/31/11 04/21/11
03/31/11 03/31/11
03/28/11 03/30/11
03/25/11 03/21/11
03/25/11 04/16/11

Criteria Cells:
Need By Date
>'Arrive Date'+5

Any suggestions?
Thanks!

 

[Dannyh1]

Hi

C2 = B2-A2 Copy down

=COUNTIF(C2:C10,">5")

 

[stuart_fort]

Thanks for the quick reply. I didn't think to mention in my initial post...

This comes from a data table that will grow with time, and I want to have the DCOUNT function operate without rely on any other formulas in the data table. Not sure if it's possible.

Thanks!

 

[markmzz]

Maybe this:

Note: this is a table with a row of total, but I used the function SUMPRODUCT.


<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">ArriveDate</td><td style=";">Need By Date</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">4/14/2011</td><td style="text-align: right;;">5/7/2011</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">4/12/2011</td><td style="text-align: right;;">4/6/2011</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">4/1/2011</td><td style="text-align: right;;">4/15/2011</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">3/31/2011</td><td style="text-align: right;;">4/28/2011</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">3/31/2011</td><td style="text-align: right;;">4/21/2011</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">3/31/2011</td><td style="text-align: right;;">3/31/2011</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">3/28/2011</td><td style="text-align: right;;">3/30/2011</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">3/25/2011</td><td style="text-align: right;;">3/21/2011</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">3/25/2011</td><td style="text-align: right;;">4/16/2011</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";">ArriveDate+5</td><td style="text-align: right;;">5</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet3</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B11</th><td style="text-align:left">=SUMPRODUCT(<font color="Blue">--(<font color="Red">(<font color="Green">[Need By Date]-[ArriveDate]</font>)>5</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[Dannyh1]

Nice