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:
Trying to evaluate for row 12 result with the following nested IF statements with a warning that there are too many arguments:HTML Code:
=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!
Bookmarks