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