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