I have a sheet that contains
column A names
column B date of admission
column C date of leave
column D date of death
column Z date of birth
I want to calculate the duration of stay (date of leave - date of admission) if date of death is empty, and
(date of leave - date of death) if there is a date of death.
I have this equation which calculates age,
=DATEDIF($Z5,TODAY(),"Y") & " Years, " & DATEDIF($Z5,TODAY(),"YM") & " Months, " & DATEDIF
($Z5,TODAY(),"MD") & " Days"
can it be modified to satisfy my need, or is there another formula to use?