Given two dates, I'd like to loop through the months. If my start date is 1-Oct-2007 and my end date is 30-Sep-2008, then I'd like my loop counter to be
10,11,12,1,2,3,4,5,6,7,8,9
as it loops through the dates. It might look like this: Sub LoopMonths()
For Month = dtStartDate To dtEndDate
[...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/01/31/looping-through-months/
Posted
Jan 31 2009, 07:15 PM
by
Daily Dose of Excel