simple formula for next month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
datMonBeg = DateSerial(Year(objCell.Offset(0, 5).Value),
Month(objCell.Offset(0, 4).Value) + 1, 1)


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 1 vs 10 in Excel Formula 0
Code Optimization 0
Runtime Error 1004 when runing Sub() from btnClick 2
Weighted randbetween text list 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Find last column & copy/paste values 1
Setting up TrueNAS frustration 4
convert spreadsheet formula into VBA formula 1

Back
Top