In attached workbook, I needed the Monthly Interest and Monthly Serv Fee columns to population with the monthly sum, if the date was the last day of the month; I currently am using SUM with OFFSET, and refencing the number of days in a given month in the OFFSET formula.
This works nicely, except at the very start of the date range, if the beginning date is not the 1st business day of the month. This is because the OFFSET formulas is then trying to sum above Row 1, which obviously returns #REF!.
Does anyone have any ideas on how to fix this problem, or rework my approach using SUM with OFFSET here?
OFFSET formula within SUM formula: OFFSET(B2,(-DAY(EOMONTH(A2,0))+1),0)