Format your start date and end date cells to a date format, then use
=DAYS360(A1,B1); A1 being your start date, and b1 being your end date. Note
that this formula bases a year on 360 days (12 months with 30 days).

"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