View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DSJR
 
Posts: n/a
Default 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
__