VBA > Loop Help > Copy, Paste, Format Date - Is there a better way to do this?

All,


Situation: Very large list of dates in column A (approximately 300-400K values) formatted as "m/d/yyyy h:mm"
Desire: Way to paste these values in Bx, Cx, and Dx each with different format for each value of x until row count.
Issue: My code literally takes 30 minutes and this step is just the first part of the code for the complete macro
Question: Is there a better way to write my code that it doesn't take so long? I'm pretty sure it's inefficient.

Bonus: I'd like to just delete the original date column once all is said and done with the loop automatically.

Example of what I'd like to accomplish:
For x = 2 to row count
Given A2 = 11/1/2018 8:59:59 AM (m/d/yyyy h:mm)
Make B2 = Nov-2018 (mmm-yyyy)
Make C2 = Nov-01 (mmm-dd)
Make D2 = 8:00 AM (needs to be rounded down to the nearest whole hour)

Please Login or Register  to view this content.

Thank you!

Thank you! It does work - my question is would you be so kind as to explain the logic? My only issue is that I had hoped to build around this code the ability to basically import the spreadsheet that actually contains those dates into sheet two, column D and then use sheet one as for the final spreadsheet once all is said and done.

Is it possible to re-reply with a version of the code for just one date so I could understand it better? it does work though! Thank you so much! It's fast too.

That makes sense. Thanks guys! I like actually learning the code and reasoning behind the code I appreciate that!