Excel vba get month from Date object

Question

I have a cell that gets filled with a date value. I then store it in a variable.

Sub dateTest()
    Dim min_date As Date
    min_date = ThisWorkbook.Worksheets("setup").Cells(22, 5).value

    MsgBox (min_date)
End Sub

However, I would like to get a month and a day separately from that object. How to do it?

Answer 1

Month() and Day() are the functions that you need:

MsgBox (Month(minDate))
MsgBox (Day(minDate))

• Microsoft Month Reference

• Microsoft Day Reference

---

Another way is to use the Format function:

MsgBox Format(minDate, "m")
MsgBox Format(minDate, "d")