Hi Eduardo,

sorry I don't think I could have explained myself correctly.

I am trying to find out on which day will my income support my expenses, ie
on which day will it become equal to the total value from January through to
April as a formula.

In reality I am working on a period from January through to December but the
example I have shown is the same principle.

Thanks

"Eduardo" wrote:

Hi Allison,
the breakeven formula should be

Total row 6 / total row 3 * 30

Which give you 23 days and it make sense since your expenses in January were
25000 and your income 51000

Hope this helped


"Allison.S" wrote:

Does anyone know the formula to calculate the breakeven day baesd on the
following:-

Income
Row 1 A B C D
Row 2 Jan Feb March April
Row 3 51,000 23,000 24289 30,000

Expense
Row 6 25,000 40,000 22,000 15,000

I believe the answer is that we shall breakeven on day 95, 5th April. But I
need to input this into a formula which will automatically refresh if the
figures get updated.

Thanks for your Help.