Forum Discussion
XL Ageing Creditor formula help
Hi, I'm in desperate need of some help please as I don't really know much about formulas, so it may be a daft question? I'm trying to create a formula for an aged creditor report however the ones I'...
If you convert the data to an Excel Table any formulas will extend to match the data
= IF(@[Total Paid] < @[INV AMT Due],
@[Payment Due Date] - reportDate,
"")