Forum Discussion

romovaro's avatar
romovaro
Copper Contributor
Sep 06, 2022
Solved

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...
  • Riny_van_Eekelen's avatar
    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.

     

Resources