I have been stumped on this particular task for weeks. Any help would be greatly appreciated.
I have three columns I am working with: Date Admitted to Hospital (date column), Date Discharged (date column), and Hospital Duration (calculated column)
Hospital Duration currently looks like this:
=IF(ISBLANK([Date Discharged]),DATEDIF([Date Admitted to Hospital],TODAY(),"d"))
This is great because it accounts for a scenario where 'Date Admitted to Hospital' is filled in, but 'Date Discharged' is blank. However, it does not account for when neither of the columns are filled out - and when BOTH of the columns are filled out, the result I get in 'Hospital Duration' is "no"??