I have big issue in excel formula

Good evening,



I have big issue with excel. I want to calculate number of days "long stay patient" from admission date based on 3 criteria.



1. if discharge patient not today, then calculate number of days " long stay patient" from admission till discharged date.



2. if expired patient not today, then calculate number of days " long stay patient" from admission till expired date.



3. if not discharge or expired, then calculate number of days " long stay patient" from admission till today.



Please see excel sheet in attachment



Thanks a lot

=if(max(l4,m4)=0,today(),max(l4,m4))-e4