I realize that B1-A1 does the trick directly. I thought it was obvious, so i
thought he was looking for a different function. Hence, why i gave him the
DAYS360 function and noted the 30 day approximation that the function uses.

"David Biddulph" wrote:

Why use DAYS360, when B1-A1 would do the trick directly (and doesn't have
the 30 day approximation)?
--
David Biddulph

"JBoyer" wrote in message
...
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