Brand new to this forum, and novice to vba
We have a log with client information. It has dates of admission and dates of discharge. I'm trying to calculate for any given period with a start and end dates how many clients were enrolled daily and then give a grand total. Right now it's only calculating a total for that period. It doesn't calculate a daily total and accumulate it. Any help would be greatly appreciated.
You can use COUNTIFS and SUMIFS to count and total entries that match several constraints, for example, >= and <= a date in a cell.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Welcome to the forum!
The attached workbook may give you some ideas. I made an list of dates and then used the SUMIFS function to create the count of patients for each day. See if you can figure it out and ask any questions you like. I am sure that you will want to generalize this.
Maria.xlsx
Bob
Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.
It sounds like you need a check register but using admitted instead of credit, discharged instead of debit and daily census instead of balance.
So, daily census = previous daily census + admitted - discharged.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks