Thread: month plus one - excel 2003
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DSJR
 
Posts: n/a
Default month plus one - excel 2003
thank you ... got it!
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)



Reply With QuoteReply With Quote