Set up your calculation =ENDDATE-STARTDATE, which will automatically format
it as a date since it is referring to dates. Then go to Format-- Cells, and
choose to format it as General (or number).
--
John C


"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