How to get the 1st of the next month's date?

A

AA Arens

How to get the 1st of the next month's date?

I do have this button script:

Private Sub CommandButton4_Click()
ActiveCell.Value = Format(Date, "mm-dd-yyyy")
End Sub

Like today is 24-03-07, push results in 01-04-07

Bart
 

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

Excluding Friday & Saturday from the calculation 1
Very strange date format behavior: 06 > 2006 / 07 > 07 5
Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
separating date and time 5
Fixing Date Format 6
Formula to fill cells based on Date of Arrival and Date of Departure 1
Date format 1
Find a Date in Excell 3

Top