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
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