LIST DAYS IN A MONTH

[sal21]

peraphs just post... sorry for that.

based M=3 and A=2023, how to list all days?

note:
M is a numeric month A is the year

[SpeakEasy]

Code: Select all

Private Sub daylist(M As Long, A As Long)
    Dim D As Long
    Dim myday As Date
    For D = 1 To day(DateSerial(A, M + 1, 0))
        myday = DateSerial(A, M, D)
        Debug.Print Format(myday, "ddd d mmm yyyy")
    Next
End Sub

[HansV]

Come on, Sal. You have asked this question (or a variation of it) several times now...

[sal21]

Come on, Sal. You have asked this question (or a variation of it) several times now...

Sorry...