Insert Missing Dates

**Sal1** · 08-04-2009, 04:15 PM

I am looking for help. Sheet1 B1:1 has dates in each column in ascending order for one month. There are missing dates in between the days and they might look like this.

Example 1

7/1/2009 7/2/2009 7/6/2009 7/7/2009

Is there a code that will insert columns with the missing dates between the dates that already exist so that example 1 would become example 2?

Example 2

7/1/2009 7/2/2009 7/3/2009 7/4/2009 7/5/2009 7/6/2009 7/7/2009

**JBeaucaire** · 08-04-2009, 08:00 PM

Give this a try:

Please Login or Register  to view this content.

**Sal1** · 08-05-2009, 11:10 AM

This is great. Thank you. The only problem I am having is that once the dates are finished filling in for the current month, dates continue to be filled in for previous months. If it’s possible I would like to stop the code after the current month is completed.

**JBeaucaire** · 08-05-2009, 11:41 AM

Show me the data you're dealing with. Click GO ADVANCED and use the paperclip icon to post up your workbook.

**Sal1** · 08-05-2009, 09:18 PM

Thank you.

**JBeaucaire** · 08-05-2009, 10:26 PM

I added one line that should fix it:

Please Login or Register  to view this content.

**Sal1** · 08-06-2009, 11:06 PM

Wow. It works like a charm. Thanks man! Your help is very much appreciated.

**VIKRAM1009** · 12-07-2012, 12:33 AM

Hi,

What would be the macro, if the same data is in rows....please help...thanks!

**arlu1201** · 12-07-2012, 01:25 AM

Vikram1009,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.