LinkBack URL
About LinkBacks
I need to calculate the census by month and year for patients with Admit and Discharge dates.
Please Login or Register to view this content.
I need to calculate the census by month and year for patients with Admit and Discharge dates.
Please Login or Register to view this content.
Hello zcavaricci. Welcome to the forum.
Assuming Admit/Discharge are in columns A/B and output starts in D3 enter this in D3:O6
Formula:
Please Login or Register to view this content.
Dave
Good Evening Dave! While your solution worked for the sample data, when I added all the patients with their Admit/Discharge Dates (and changed the formula to look at the extra rows), the calculation seems to not work? I have attached the excel workbook.
Please try E3 and copy acro
=SUMPRODUCT(($B$2:$B$111>=--(E$2&$D3))*($A$2:$A$111<=--(E$2&$D3)))
I get different numbers than Bo_Ry with this ... for example 38 for 9/2018 ... which I believe is correct.
Formula:Please Login or Register to view this content.
Dave, You're right. It should be 38
Need to add Eomonth
=SUMPRODUCT(($B$2:$B$111>=--(E$2&$D3))*($A$2:$A$111<=EOMONTH(--(E$2&$D3),0)))
Thank you FR and BR!!! Great work, I could never have figured out those formulas!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks