Forum Discussion
romovaro
Sep 06, 2022Copper Contributor
Coalesce function - Date Difference
HI all I have a column called LOA Signature date and another one call Signed Date. I am trying to find a formula that calculates the difference in months from the LOA Signature date to Today (In...
- Sep 06, 2022
romovaro You would have to IF and ISBLANK as COALESCE doesn't exist in Excel.
Perhaps something like this:
If your data in Excel sits is a structured table, you can obviously use structured table references.
Riny_van_Eekelen
Sep 06, 2022Platinum Contributor
romovaro You would have to IF and ISBLANK as COALESCE doesn't exist in Excel.
Perhaps something like this:
If your data in Excel sits is a structured table, you can obviously use structured table references.
romovaro
Sep 06, 2022Copper Contributor