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
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