I have a large worksheet with information as follows:

Example (Col A/Col B/Col C)
Date Hired/Date Terminated/Total Days Worked
7-1-01/8-31-01/61

I need to determine how many days were worked in both the 2000-2001 fiscal
year (8-1-00--7-31-01) and the 2001-2002 fiscal year. In the example, the
desired return would yield 31 and 30 days, respectively.

I've had no luck finding such a formula or even something to start with.
Does anyone have an bright ideas of how to accomplish this?