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...t?usp=drivesdk