Forum Discussion
XL Ageing Creditor formula help
Hi Zed69
this could be one solution:
=(A12-TODAY())*ISBLANK(C12)
The first part counts the difference between the due date and today.
The ISBLANK function checks, if there is something entered in column C.
If C12 is blank, it returns true (which equals to 1), so the date difference gets multiplied by 1.
If C12 is not blank, it returns false (which equals to 0), so the date difference gets multiplied by 0.
Martin_Weiss Omg, that's excellent, thank you so much 😄
Shouldn't have spent weeks researching but come on here weeks ago.
Appreciate it, thanks
Peter, I couldn't get yours to work, as it kept coming up with a formula error. I've obviously missed something along the way?
I entered the following, but clearly it's incorrect. What have I done wrong please? Thank you
=IF(@[O20]<@[L20],@[I20]-N9,"")
My guess is that you did not convert the data to a Table (Ctrl/T) or name the cell containing the report date.
