Calculate accrued income during promotion periods using Excel formulas that handle invalid dates and prevent division by zero errors.