IF Statement - # of days in (date range 1) that fall within (date range 2)

Hi there,

I would like to find the # of days in a policy term that fall within a stated accounting period. The # of days will be used to calculate prepaid expense for the month.

Example:

Policy Term: 7/15/10-7/14/11
Accounting Period: 7/1/10-7/31/10

For this period, 17 days would fall in the period. For the last period (7/1/11-7/14/11, 14 days would fall in the accounting period. 100% of the days between months would be counted. Days occuring before or after the policy period date range would not be counted.

Here is what I've been working on:

HTML Code: 

Trying to evaluate for row 12 result with the following nested IF statements with a warning that there are too many arguments:

=IF(AND(D12>=B12,D12<C12),MAX(C12-D12+1,0),IF(E12>C12,0),IF(AND(E12<C12,E12>B12,C12>E12),E12-B12+1,C12-B12+1))

I am including the excel workbook that I've been working on in the case that the above information is insufficient. It is entirely possible that I am making matters much too complicated, so your additions, deletions, corrections and suggestions are most welcome.

Please forgive any newbie format issues (just this once)

Thanks!

Hi

I would enter the start date for your financial year in cell C1 on sheet Input

Then in cell K8 enter
=$C$3-$C$2+1-MAX(0,F8-$C$2)-MAX(0,$C$3-G8)

in cell M8 enter
=$C$3-$C$1+1-MAX(0,F8-$C$1)-MAX(0,$C$3-G8)