Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate # of days
If I have an admission date and a discharge date, how can I write a formula
to calculate the number of days between the two dates? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate # of days
weird, i should have just tried discharge - admission date. works fine.
"Jonathan" wrote: If I have an admission date and a discharge date, how can I write a formula to calculate the number of days between the two dates? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate # of days
On Wed, 4 Mar 2009 11:06:05 -0800, Jonathan
wrote: If I have an admission date and a discharge date, how can I write a formula to calculate the number of days between the two dates? With your two dates in cells A1 and B1 the following formula gives the number of days: =B1-A1 Hope this helps / Lars-Åke |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to calculate # of days
Not weird at all.
Serial number of Discharge date is greater than serial number of Admission date. March 4, 2009 serial is 39876 February 4, 2009 serial is 39848 Gord Dibben MS Excel MVP On Wed, 4 Mar 2009 11:09:03 -0800, Jonathan wrote: weird, i should have just tried discharge - admission date. works fine. "Jonathan" wrote: If I have an admission date and a discharge date, how can I write a formula to calculate the number of days between the two dates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate days | Excel Discussion (Misc queries) | |||
calculate days | Excel Discussion (Misc queries) | |||
Calculate the Days | Excel Worksheet Functions | |||
calculate days | Excel Worksheet Functions | |||
HOW TO CALCULATE THE DAYS? | Excel Worksheet Functions |