I am getting frustrated with a formula I am trying to use in SharePoint. My formula is to calculate # of days hospitalized. I am wanting to calculate the number of days hospitalized via calculating admit date from both today and the discharge date. In other words, If the Discharge date is blank, calculate Admit date from today and if discharge date is entered, admit date from discharge date. I have this set up in Excel and it is working fine. When I translate it over to SharePoint, it gives me a syntax error.
Excel formula –
IF(ISBLANK(DISCHARGE DATE), TODAY-ADMIT DATE, DISCHARGE DATE-ADMIT DATE)