I'm using the following formula to calculate cost of funds:
=(SUM($E4:I4)-SUM($V4:$W4))*$AJ$2*(AN$3/360). $E4:I4 is capital, $V4:$W4 is
depreciation, $A$J2 is the cost of funds rate, and AN$3 is the number of days
in the month. In this case, AN$3 = 31. But I want AN$3 to read "May". How
would I modify the formula to convert "May" into 31, "June" into 30, etc.

Algebraically, the math is: Cost of funds = [Net book value]*[COF
rate]*{[days in month]/360}

Thanks.

Dave


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.