Hi Again Linda,

Another solution that you might consider if you are downloading data from
Access on a regular basis. In Access you can create an Append query that
send the date/time field to a Number (Long Integer) field. From there you
can send the data to Excel. There might be some other steps to do in Access
depending on exactly what you are doing. When the date comes into Excel you
will just need to format them as dates, no times will be imported.

Cheers,
Shane Devenshire
Microsoft Excel MVP

"Linda RQ" wrote in message
...
Sorry Guys,

I have looking around on a bunch of websites on calculating days between
dates (sort of) and it's almost working but I need it to really work.

I need a cell to return the number of days a patient was on a ventilator.
Here is my latest try. I get the right number but it's a negative number

=DAYS360(G10,F10)-1

Start Date 1/10/08
End Date 1/18/08

The answer should equal 9. I know the difference between these 2 is 8
but we count each day the patient is on the vent as if it were a whole
day.

So what do I need to do to get this answer from these dates?

Thanks,
Linda