Thread: simple formula for next month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ameliacat ameliacat is offline
external usenet poster
  
Posts: 2
Default simple formula for next month
Here is the formula for the beginning month:

datMonBeg = DateSerial(Year(objCell.Offset(0, 5).Value),
Month(objCell.Offset(0, 4).Value), 1)

Now I want to reference the following month. Is there a simple formula for
this?



Reply With QuoteReply With Quote