smallEVILS
2021-01-23, 07:49 PM
Hi, i'm currently create a excel data to calculate my earning and expense in a month. I need help to create formula to calculate average amount for upcoming earning i need to make to reach all my expense amount (i've fixed expense and daily expense). Let’s say from 1 Jan 2021 - 20 Jan 2021 my earning and expense is :
Earning $1000
Expense $1500
$1000 (fixed)
$500 (daily)
So, what is the formula to calculate average for upcoming 11 days for Jan 2021 ?
I want to copy the formula for February 2021 with $1000 expense (fixed)
Thanks in advance :)
To make it more clear with 5 days income & expense, please open this spreadsheets link -> https://docs.google.com/spreadsheets/d/1SY6vYR_2Kdxx7dBK92CWtcYKcYp0bmAiawLXAkM5ZVY/edit?usp=drivesdk
Earning $1000
Expense $1500
$1000 (fixed)
$500 (daily)
So, what is the formula to calculate average for upcoming 11 days for Jan 2021 ?
I want to copy the formula for February 2021 with $1000 expense (fixed)
Thanks in advance :)
To make it more clear with 5 days income & expense, please open this spreadsheets link -> https://docs.google.com/spreadsheets/d/1SY6vYR_2Kdxx7dBK92CWtcYKcYp0bmAiawLXAkM5ZVY/edit?usp=drivesdk