Make a counter

**choy96** · 04-04-2012, 11:09 AM

i need a formula can be count total stock was produce between last collect day and today,production will produce 2000 per day, example last collect date is 04-Mar-12 , today is 06-Mar-12 , the result will be 4,000.

thanks.

**Dennis7849** · 04-04-2012, 11:54 AM

Take a close look at cells(B3 to F3). See your modified workbook attached.

**choy96** · 04-04-2012, 07:20 PM

Thanks Dennis7849 very much.

May i have a formula that straight can be total day multiple to qtty per day ?
I have try =b3-today()*2000 , but it return a wrong result , anyone help ?

thanks

**Paul** · 04-04-2012, 07:23 PM

Hi Choy,

I think you need to adjust for proper order of operations. Try:

=(B3-TODAY())*2000

This will first subtract today from B3, then multiply that difference by 2000. In your attempt it is multiplying TODAY() by 2000 (a very large number since today's serial date is 41003) and then subtracting that from B3.

**Dennis7849** · 04-04-2012, 08:18 PM

=(B3-TODAY())*2000

this should yield a negative value because 'Today()' will alway be larger than any previous date.

the correct form should be

=(TODAY()-B3)*2000