View Full Version : What is the formula to do an average calculation for missing data?

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