It sounds like you might have been confused by Excel's attempt to
maintain consistent formatting.

The formula is nothing more than =C2-B2, but because these are dates,
Excel guesses that the result is also a date. All you need to do is go
to Format/Cells... and select the appropriate format for the number.
You can abbreviate the process by clicking the Comma Style button
(looks like a comma) to apply your formatting but it will give you 2
decimal places by default.

On Jul 7, 12:10*pm, Jack wrote:
Hello,

Please write a formula for me that will give m,e the difference between two
dates.
My fields are like this.
Start Date * * *End Date * *Total Days

7/10/08 * * * * *7/15/08 * * * * *5 *

What the total day box need to be in days not dates.

Thanks