I am trying to create a travel log with continuous dates in first column. I want to double the entry for Fridays and Mondays so that it looks like this. When I use the fill handle it goes back and starts over with the January 1 and basically copies what I have put down rather than recognizing the pattern and continuing the dates for the entire year. Any thoughts? Here is a sample of pattern.
Sunday, January 1, 2017
Monday, January 2, 2017
Monday, January 2, 2017
Tuesday, January 3, 2017
Wednesday, January 4, 2017
Thursday, January 5, 2017
Friday, January 6, 2017
Friday, January 6, 2017
Saturday, January 7, 2017
Sunday, January 8, 2017
Monday, January 9, 2017
Monday, January 9, 2017
Tuesday, January 10, 2017
Wednesday, January 11, 2017
Thursday, January 12, 2017
Friday, January 13, 2017
Friday, January 13, 2017
Saturday, January 14, 2017
Sunday, January 15, 2017
etc.
Solved by T. H. in 14 mins