Help Creating a list of Dates! Please HELP! Thanks

[PatrickMilano21]

Hi,


I am looking to create a macro with a list of Dates and Times. I want to be able to have the user input the start date and start time (Ex. 9/7/2014 14:00) and an end time (Ex. 12/5/2015 3:00) and have excel fill a column with the dates starting at the start time every hour until it reaches the end time. Please help!! THank you


Example: Col 1

Row1: 9/7/2014 14:00
Row2: 9/8/2014 15:00
Row3: 9/9/2014 16:00
etc
etc.
Last Row: 12/5/2015 3:00

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...st-dates-using-visual-basic-applications.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).