| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count maybe?
I need to calculate the days coverage i have for my inventory. I start with
90660 units on 2-23 and then subtract my sales from my inventory. How many days do i have before my inventory will go negative. I need to calulate this daily over a period of time. Is there a formula i can use? Date Days Cov Sales Iventory FRI 02/23/07 90660 SAT 02/24/07 5D 10044 80616 SUN 02/25/07 4D 6696 73920 MON 02/26/07 3D 14580 59340 TUE 02/27/07 2D 18624 40716 WED 02/28/07 1D 18624 22092 THU 03/01/07 22656 -564 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
