Hi,

Not sure where to start.

I've got dates formatted like:
8/31/2018 (As text)

I'd like to pick out the oldest and newest date in a column
Then fill in a second column starting with the oldest and ending with the newest

If someone could point me in the right direction that would be great. My VB is poor on a good day.

For example:

Input Output
9/6/2018 8/31/2018
9/2/2018 9/1/2018
8/31/2018 9/2/2018
9/3/2018
9/4/2018
9/5/2018
9/6/2018