Need more help with formula

[George]

I posted the following the other day and received a few answers.

It appeared to be working but it is simply subtracting the two columns
rather then the different bewteen the two dates.

With the formula I was given if I enter in column C3 01/03/2008 and column
D3 01/04/2008 it gives me 1 day, should be 2 days.

Here is what I asked !

I need help with a formula for Cell E3 that will give me the total days
between cell C3 and D3 - Here's what I am trying to do.

Column C3 - Enter Deployment Start Date

Column D3 - Enter Deployment Return Date

Column E3 - Total Days Deployed

As of now I am using =SUM(D3-C3) but it does some strange things.
If only C3 or D3 are filled in it gives a bogus number until both cells are
filled
in. Also it always displays the number zero unless a value is entered - I
would rather the cell remain blank if cells C3 and D3 are blank.

Thanks

 

[T. Valko]

Try this:

=IF(COUNT(C33)<2,"",D3-C3+1)

 

[Bob Phillips]

=IF(OR(C3="",D3=""),"",D3-C3+1)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)