Sep 06 2022 03:47 AM
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 case LOA signature Date is blank, then the formula needs to use Signed Date)
Ageing = DATEDIF(TODAY()-"LOA Signature date and if blank, Signed Date"...
I created this formula for my PowerBI report but I don't know how to use same formula in Excell...any tip?
Sep 06 2022 04:06 AM - edited Sep 06 2022 04:08 AM
Solution@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.
Sep 06 2022 04:06 AM - edited Sep 06 2022 04:08 AM
Solution@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.