Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
days and dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Dates / Days | Excel Discussion (Misc queries) |