Forum

Notifications
Clear all

count between 2 columns depend on month range

3 Posts
2 Users
0 Reactions
177 Views
(@band)
Posts: 2
New Member
Topic starter
 

Hi,

I have question,

I want count number of patient depend on admission and discharge date, also count total days on the same month

here is an example it should count number of patient in specific month even the patient extent to next month will count one in next month.

So I need how to count Total Patient and Total days based on month period.

thanks a lot

please see attachmenttest.JPG

 
Posted : 13/06/2020 8:52 pm
(@band)
Posts: 2
New Member
Topic starter
 

Hi

 

My question solved in excelforum.com

 

https://www.excelforum.com/excel-formulas-and-functions/1319085-count-depend-on-month-range.html#post5349018

 

Thank you very much

 
Posted : 14/06/2020 1:04 am
(@purfleet)
Posts: 412
Reputable Member
 

Luckily you only posted the question it at least 4 other forums

 
Posted : 14/06/2020 3:07 am
Share: