admission

hi all, just need a tidier way of getting my days allocated to the months in which they fall. my data represents the duration of stay for patients in hospital. I have an admission date and a discharge date (in most cases). I am using the following formula to distribute the total number of days...

<tbody> Class Admission Withdrawal PG 11/16/17 PG 11/16/17 Nur 08/1/17 11/16/17 </tbody> Required answer <tbody> Class Admission Withdrawal PG 2 Nur 1 1 </tbody> Kindly Help

<tbody> GR# Name Head Amount 12 Usman Security 25000 12 Usman Admission 25000 12 Usman Tution Fee Aug 17000 13 Ali Security 25000 13 Ali Admission 25000 13 Ali Tution Fee Aug 17000 14 Omar Tution Fee 17000 </tbody> <tbody> GR # Name Security Admission Aug Sep 12 Usman 25000...

putting GR # in column B and result will show the total number of class admission. A B C D E Reg # GR# Class Class 1 2 (Answer should be 2, cause B5 is empty. that mean no...