how to get the following output(reference image below) using VBA for getting list of dates from a particular date to particular date?

[abhi221996]

HOW CAN I GET THIS OUTPUT USING VBA?

 

[abhi221996]

Thanks saurabh for your response actually I was stuck in a problem linked below I thought you might be able to help.
simple calendar problem

Hello Abhi,

Below code we can use if would like to use DateAdd method.

Sub showDates()

Dim fromDate As String, toDate As String
Dim rowno As Integer

fromDate = "12/15/2021"
toDate = "10/1/2022"

Worksheets("Sheet2").Cells(1, 2) = fromDate

For rowno = 1 To DateDiff("d", fromDate, toDate)
    Worksheets("Sheet2").Cells(rowno + 1, 2) = DateAdd("d", 1, Sheets("Sheet2").Cells(rowno, 2))
Next

End Sub