Calculation between two dates

K

Kipirich

Hi

Have requested some help on this topic but perhaps I should give you the full picture as to what my plan is.

Table is as follow:
Prod ID
Date
Shop
Product
Pack
Singles
Baked
Damaged

At monthend I want to enter my last day trading stock ie 31/10/2009
The next monthend I want to enter my last day trading stock ie 30/11/2009

I want to calculate between those two dates the value and units of stock :

Date Product Cost Units Value
ie 31/10/2009 Soap 1.00 4 4.00
31/11/2009 Soap 1.00 2 2.00
Total 2 2.00

I want to achieve Opening stock - Closing STock. Last months m/end stock will then become this months Opening stock....

Is there someone out there who will be able to help
I hope it is clear what I want to do
Thanks for all your help
Kipirich
(e-mail address removed)




--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation between two dates 1
rst.findfirst not working with two conditions 6
Months between two dates 5
Count between two dates using sumproduct 6
If Formula and Dates 4
Difference between two dates 8
Calculate working hours between two dates 2
Selecting all days between two dates. 3

Top