calculating days of stock

  • Thread starter Thread starter Cor
  • Start date Start date
C

Cor

Hi,

I need a formula for this in:
Coloms
A | B | C | D | E | F | G | H etc
Stock (today) |<DAYS OF STOCK> |sales tomorrow | Sales day after tomorrow| forecast day 1| forcast day 2| forcast day 3| etc

100 | | 15 | 12 | 18 | 25 | 34


The outcome in column B must be apr. 4,88 which is 4 day's +


Thanks in advance,
 
You could have something like
=A2/average(C2:L2) which will give you 4.807

You could also just deduct the sum of projected days from the stock to see
a positive or negative balance.
=A2-SUM(C2:L2) which will give you -4

Allowing for your etc.... up to L column.


--
Groeten vanuit Nieuw Zeeland
Willy Kuunders
Hi,

I need a formula for this in:
Coloms
A | B | C | D | E | F | G | H etc
Stock (today) |<DAYS OF STOCK> |sales tomorrow | Sales day after tomorrow| forecast day 1| forcast day 2| forcast day 3| etc

100 | | 15 | 12 | 18 | 25 | 34


The outcome in column B must be apr. 4,88 which is 4 day's +


Thanks in advance,
 
Back
Top