Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating within Date Ranges
I've gone through the threads and haven't found a solution to my problem.
For simplicity's sake, let's say I have 4 columns Category, Start Date, End Date, Total Number of Days. On a monthly basis, I need to calculate the number of days completed for each of 8 categories. The date range spans months. If I were to write it out, the querry would be if <category in column A = "x", count number of days up to and including Aug 31st." Any help is most appreciated... MB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Airline MAWB Ranges | Excel Discussion (Misc queries) | |||
Calculating Date Ranges | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating with named ranges | Excel Discussion (Misc queries) | |||
calculating date time ranges | Excel Worksheet Functions |