Basically, I have a list of dates with respective balances. And I was wondering how to get Excel to determine if the end of the month has passed after a certain date and then calculate the return for that month. (I know how to calculate the return for a given set, but I'm not sure how to get Excel to do this automatically, since there are different numbers of days in each month.)
Okay, I figured i can test to see if there's a change in the month by using an IF and a MONTH function. But how do I get the range of the average taken to be exactly the number of days in that month? (Number of days in my spreadsheet does not equal total number of days in the month.)