Private Sub Command1_Click() Dim dDiff As Integer, dStart As Date Dim i As Integer dStart = CDate("2009-08-01") dDiff = DateDiff("d", dStart, Now)For i = 0 To dDiff - 1 Debug.Print Format(DateAdd("d", i, dStart), "yyyy-MM-DD") Next End Sub具体你要输出到哪自己改下就好了
Private Sub Command1_Click()
Dim dDiff As Integer, dStart As Date
Dim i As Integer
dStart = CDate("2009-08-01")
dDiff = DateDiff("d", dStart, Now)For i = 0 To dDiff - 1
Debug.Print Format(DateAdd("d", i, dStart), "yyyy-MM-DD")
Next
End Sub具体你要输出到哪自己改下就好了