Shane,

Thank-you. I saved these two option to try later. I have to change the
format of my dates when I use my Monarch program too. I would have thought
the 2 Microsoft programs would know how to deal with each other but after
reading Biff's explaination, I "get it"...sort of <g

Linda


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