count between 2 columns depend on month range

[band]

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 attachment

 

[band]

Hi

My question solved in excelforum.com

count depend on month range [SOLVED]

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...

www.excelforum.com

Thank you very much