We’re looking at transactions from the current year, starting 1st January up to last month.
To figure out the average amount for a certain day, we check what was spent on that same day each month, then take the average.
Example – Average for the 20th of Each Month:
Date | Value |
|---|---|
20 Jan | £100 |
20 Feb | £70 |
| 20 Mar | £120 |
| 20 Apr | £30 |
20 May | £0 |
20 Jun | £50 |
Add them up: 100 + 70 + 120 + 30 + 0 + 50 = 370, then divide by 6 months: 370 ÷ 6 = 61.67
So, the average for the 20th day is £61.67
We do this for each day of the month, and then add all the daily averages together to get the projected total for the month.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article