month plus one - excel 2003
thank you for your help!
d
"Richard Buttrey" wrote:
On Sun, 21 May 2006 19:21:38 +0200, "Ardus Petus"
wrote:
Hi DSJR,
=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())
HTH
Probably a typo, but aren't there some ( ) missing ?
=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))
and formatted as "mmmm" of course
:-)
RB
__
|