What is the formula to do an average calculation for missing data?

smallEVILS

New member
Joined
Jan 23, 2021
Messages
1
Reaction score
0
Points
0
Excel Version(s)
google sheet
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/spreadsheet...92CWtcYKcYp0bmAiawLXAkM5ZVY/edit?usp=drivesdk
 
Top