# calculating days of stock

1. ## calculating days of stock

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 +

2. ## Re: calculating days of stock

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
"Cor" <cor@whatuwant.nl> wrote in message news:d5geft\$grr\$1@news2.zwoll1.ov.home.nl...
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 +

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1