Loop through Dates

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is there an easy way to start a loop through days given a beginning and
end date. The first thing that came to mind for me was something like
the following:

***********************************************************************************************************
Dim i as Date

For i = 12/1/2006 To 12/5/2006
Msgbox i
Next i
************************************************************************************************************

This did not work ... when I formatted it it gave me come crazy date
like 1/11/2237. I feel like I have to do something like this, I am
just not sure what.

All Help is Appreciated.
THANKS!
 
Back
Top