Forum Discussion
Excel formula for Ageing
Hi, I am trying to come up with a formula to net down aged data but I am struggling! This is a sample from my pivot, I want to run the formula alongside it and what I am trying to do is: Fo...
Ensure you adjust the formula to match your actual cell references. Change Customer 1 to whatever customer you have in mind, or adapt the formula to use cell references for this. Using this summary method allows your formula to adjust as your pivot table data refreshes.