I need a formula to input a date according to other cells. For example:
I have "Term" in D5, "Activation Date" in E5 and "Renewal Date" in F5.
I need a formula in the Renewal Date column to tell me when the term is complete according to the activation date. The terms are either 3, 6, or 12 months.
I do not want to use conditional formatting to color any cells.
Any help is appreciated. Thank you.
Bookmarks