Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning data from within a date range
I have a list of contracts with daily volumes and dates which start and end
at various points over months/years organized in rows. Next to the this I have columns for every calendar month moving years into the future. What I need to do is have a formula to return the average contract volume applicable to every given calendar month across the months. ie. If the contract was for 30 units per day and the contract date started Nov 30/07 then the average daily volume for Nov/07 would be 1 unit. Any help will be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for returning date entered by date on another worksheet | Excel Worksheet Functions | |||
Look up data for date range | Excel Worksheet Functions | |||
How to sum a data range thru and after a cut off date | Excel Programming | |||
Returning value from a range of data | Excel Discussion (Misc queries) | |||
Finding data in a Range / Returning Cell Location | Excel Programming |