Differences between Dates
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
|