Forum Discussion
linards2000
Feb 23, 2021Copper Contributor
Average days to pay invoice.
Hello. So I have this task where I need to calculate after how many days on average each company pays their bills. Between the set date to pay the invoice and actual day when it's paid for each comp...
HansVogelaar
Feb 23, 2021MVP
I'd use a pivot table.
I added a column Dienų skaičius to the source data with formula =D2-C2.
The pivot table calculates the average of this column for each company.
See the attached version.
- linards2000Feb 23, 2021Copper ContributorAmazing. Thanks!