Count between dates

[Kidmon]

I need to count the number of days between dates in columns.
Column A (1/1/12) and column B (1/27/12) = 26

My problem is that I need the formula in each column to be continuous and not enter a 0 if the cell is blank

This formula return a VALUE error msg.
=DAYS360(B:B,C:C)

I have also tried =DAYS360($B:$B,$C:$C)

Thanx for your help

 

[Smitty]

How about:

=IF(B9,B9-A9,"")

HTH,

 

[Kidmon]

How about:

=IF(B9,B9-A9,"")

HTH,

Thank you but not quite. It does count the number of days and enters no 0. But I still need the formula to continue the entire length of the column with out manually 'stretching' the last cell. I am close bu, It still is not continuous.
Thanx again.

 

[Kidmon]

Thank you but not quite. It does count the number of days and enters no 0. But I still need the formula to continue the entire length of the column with out manually 'stretching' the last cell. I am close but, It still is not continuous.
Thanx again.

I have changed the formula to =IF(B2,$C2-$B2,"") and this now continues down the column but it stops at row 39. How can I make the formula continue automatically as needed?
Thanx again

 

[Smitty]

I'm not sure what you mean by it stops at row 39?

Can you post a shot of the sheet?

 

[Kidmon]

I'm not sure what you mean by it stops at row 39?

Can you post a shot of the sheet?

I will try to post a screen shot, first I need to learn how. Until then, the formula works fine on rows 1-39 and then starting a row 40 the formula disappears and is now blank.

 

[Smitty]

Take a look at the HTML Maker link in my sig for how to post a screen shot.

How exactly does the formula disappear?

 

[Kidmon]

Sorry the screen shot is not working for me.

The formula dissapering is the absence of anything in the cell.
Cell D39 has the formula in it and working and when I jump to cell D40 the cell is blank. Everything works until that cell.
An example is
Cell D25 contains =IF(B25,C25-B25,"") Cell D30 contains =IF(B30,C230-B30,"") Cell D39 contains =IF(B39,C39-B39,"") and then Cell D40 contains a blank cell. Nothing is in it.

 

[Smitty]

Do you perhaps have some event code that's deleting it? Or is the sheet protected with formulas set or formatted to Hidden?

 

[Kidmon]

Thanx for your help in the past. I never could find the problem I simply started a new sheet. I am still learning a great deal about excel. I really appreciate this forum.