Is there any method in VBA such that when a start data and end date is keyed in by the user, the code itself can find capture and output the dates in between the 2 user entered dates.
input=> [COLOR="Magenta"]start_date = 1st Jan 07[/COLOR]
input=> [COLOR="magenta"]end_date = 5th Jan 07[/COLOR]
ouput=> [COLOR="SeaGreen"]date_in_between_inclusive is 1st Jan 07, 2nd Jan 07, 3rd Jan 07, 4th Jan 07, 5th Jan 07[/COLOR]
Can anybody help me ?