cereskinomoto2004
New Member
Hi,
I kindly need help on one of my projects please
1) How do you group the same patients together
2) A formula in column D that will calculate consecutive admissions (new admission date minus last date of discharge), see sample attached.
3) A formula in Column E that will reflect readmission/s, if the difference in column D is <30 days and New admission if > 30 days.
4) A formula that will flag readmissions <30 days
Hope to hear from you guys. Many Thanks.
I kindly need help on one of my projects please
1) How do you group the same patients together
2) A formula in column D that will calculate consecutive admissions (new admission date minus last date of discharge), see sample attached.
3) A formula in Column E that will reflect readmission/s, if the difference in column D is <30 days and New admission if > 30 days.
4) A formula that will flag readmissions <30 days
Hope to hear from you guys. Many Thanks.