Create a named formula called "NextMonth" that will give the name of the month following the current month.

For our purposes add $30$ to Today$()$ to get the following month. If the current month is January, February should appear in the box as it already contains the formula name.

The value should be an excel date $($not text$)$ so it can be used in other formulas.Create a named formula called "NextMonth" that will give the name of the month following the current month.

For our purposes add $30$ to Today$()$ to get the following month. If the current month is January, February should appear in the box as it already contains the formula name.

The value should be an excel date $($not text$)$ so it can be used in other formulas.