I am trying to determine if there is a certain function used within healthcare when determining Length of Stay (LOS). In healthcare, if a patient is admitted and discharged on the same day, their LOS is 1 day. All other LOS can simply be cacluated with the formula (discharge date - admission date); however, using that formula for same-day patients yields a result of 0 days, which is wrong in this case. Is there a work around for this?
what do you want as a result for a multi day stay? Let's say they came in Monday and went home Tuesday, did they stay 1 day or 2 days? Some health insurers count a day when they have a room and board charge that isn't an ER room charge. What if they came in in the morning and were released in the afternoon (to the ED and from the ED) do you have a day charge?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
In this instance, the general rule is the day of admission is counted but the day of discharge is not. A simple formula of (discharge date - admission date) works for all calculations except the same-day calculation (I've run them both ways -- manually on paper and via Excel -- and the formula I mentioned works fine....just not for same-day).
so assuming the discharge date is in B1 and admission date is in A1, this should work for you... =IF(B1=A1,1,B1-A1)
EDIT: this would also work...=MAX(B1-A1,1)
Last edited by Sam Capricci; 01-31-2020 at 04:16 PM.
Yes! That did the trick! Thank you so much!
Good, glad that worked for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks