DUE NEXT Formulas Consider Criteria From Setup Sheet

[billy60]

Hello,

I have formulas for DUE NEXT column J of the House Schedule sheet. Can these formulas consider the notes from the Setup sheet for the FREQUENCY selected (column G). They work fine for the Daily, Weekly, and Bi-Weekly. But for the Monthly, Seasonally, Semi-Annually, and Annually is where the formulas need adjustment based on the notes from the Setup sheet.

Can these formulas in column J be adjusted to allow for these criteria?

Thank you for your help

[CheeseSandwich]

Maybe:

Please Login or Register  to view this content.

[billy60]

That is perfect! Thank you

May I ask how you stacked the formula sections? It seems to be easier to see how each criteria affect the results.

[CheeseSandwich]

Happy to help

When creating the formula you can use ALT+RETURN to enter a line break in the formula

[billy60]

Thank you I will use that technique when developing long formulas.