Hello!
I am having an issue with the attached spreadsheet that the formulas in the tax and insurance schedules are not updating correctly unless I click in to the formula in the cell and hit enter. I have already checked and the sheets are all set to Automatic calculations so that is not the issue. The formulas still calculate when I change one of the cells being checked in the if statement (E17, for example) but the formula is now applying to the wrong cell unless I click on it and hit enter. I have attached a test spreadsheet for reference.
What I need the formula to do the in the sections "Tax Schedule" (A54-A69) and "Insurance Schedule" (G54-G69) is if the month is 1 less than the month of the next disbursement (E17, E18, E19, and/or E20) then the month needs to show up 2 times in a row in the date column (ie. if next disbursement is 5/1/2021, then April 2021 should be on the schedule twice). Currently, if the disbursement date in cells E17-E20 are changed, the formula seems to set the duplicating date back 2 months instead of 1 unless I manually update the formula. I have a similar formula in the schedules in the "payment" column (column B) that works correctly even when I change the disbursement date but column A refuses to update. Any help would be appreciated!
