Ardus .. when I enter this formual I get an error .... is the formula
=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY()) where there is an open/close
parenthesis () after the final today? .. followed by a closed )? Is the HTH
part of the formula?
d
"Ardus Petus" wrote:
Hi DSJR,
=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())
HTH
--
AP
"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)