cd.

if you replace in B2:E2 Jan, Feb, March... with figures 1, 2, 3... you
might use the following formula:
(and E13=total expenses, E12=total income)

=SUM(DAY(DATE(2009,B2:E2+1,0)))*E13/E12

array-entered = with CTRL+SHIFT+ENTER rather than just ENTER (if you
insert the formnula correctly curly braces { } will show)

adjust ranges to suit

HIH


On 21 Kwi, 14:36, Jarek Kujawa wrote:
seems little data but presuming:

1. 120 days from Jan 1 till April 30
2. income per day =1.069075=120/102 (102 being total expenses)
3. =102/1.069075=95.41 days till income matches expenses

=(total days in a period)*(total expenses)/(total income)

HIH

On 21 Kwi, 13:02, 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.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -