J Jonathan Mar 4, 2009 #1 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?
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?
L Lars-Åke Aspelin Mar 4, 2009 #3 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? Click to expand... With your two dates in cells A1 and B1 the following formula gives the number of days: =B1-A1 Hope this helps / Lars-Åke
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? Click to expand... With your two dates in cells A1 and B1 the following formula gives the number of days: =B1-A1 Hope this helps / Lars-Åke
G Gord Dibben Mar 4, 2009 #4 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
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
