Get all dates of the year and weekends

nymphetamine

I now know the year and month, such as 2016, May

What I want to do is fill the following into a line of EXCEL:

For all dates from May 2016 to the end of the year, if you encounter Saturday and Sunday, you must modify the corresponding CEll color
(The date of February is different in different years)
What should I do? Is there any useful method that I ca n’t get started, please help

yoh2006

Private Sub Command1_Click()
    Dim dd As Date
    dd = CDate("2016-05-01")
    Do While (Year(dd) = "2016")
        If Weekday(dd, vbMonday) = 6 Or Weekday(dd, vbMonday) = 7 Then
            Debug.Print dd; "(weekend)"
        Else
            Debug.Print dd
        End If
        dd = DateAdd("d", 1, dd)
    Loop
End Sub