My formula updates the next date still works but stop working to update the %due column.
My formula and screenshot
=IF(AND(ISDATE([Last Date]@row), ISNUMBER(Frequency@row)), DATE(YEAR([Last Date]@row) + (FLOOR((MONTH([Last Date]@row) + Frequency@row - 1) / 12, 1)), IF(MOD(MONTH([Last Date]@row) + Frequency@row, 12) = 0, 12, MOD(MONTH([Last Date]@row) + Frequency@row, 12)), DAY([Last Date]@row)), "")
