Welcome to FreeSoftwareServers Confluence Wiki

https://stackoverflow.com/questions/35921124/how-to-get-current-month

Sub Test()
Dim Month As Long, Day As Long, Year As Long
Month = Format(Date, "m")
Day = Format(Date, "d")
Year = Format(Date, "yyyy")
MsgBox Month & Day & Year
End Sub
  • No labels

This site is just a Tech Blog, nothing is guaranteed!