count between 2 columns depend on month range|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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