Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Calculate the qty b/w two dates
In Sheet 1 the table is as below
SL.NO Received Dia Qty (MT) 1 29-Mar-03 20 19.89 2 31-Mar-08 10 6.51 3 31-Mar-08 10 0.63 4 11-Apr-08 10 1.43 5 27-Apr-08 20 8.23 6 28-Apr-08 20 25 7 3-May-08 16 9.77 8 3-May-08 20 10 In sheet 2 the table is as below Starting Date Closing Date 8 10 12 16 20 25 32 1-Jun-08 30-Jun-08 1-Jul-08 31-Jul-09 1-Aug-08 31-Aug-08 I need the qty recieved b/w two dates based on the Dia Of Bar |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA calculate avg dates | Excel Discussion (Misc queries) | |||
Calculate dates | Excel Worksheet Functions | |||
calculate dates | Excel Discussion (Misc queries) | |||
How do I calculate an age from 2 dates? | Excel Worksheet Functions | |||
How do I calculate dates? | Excel Worksheet Functions |