I have Column A with a date and Column B with a Number.

The dates may skip a day or two or more.

What I need is to expand that data into a date range, i.e. May 21, 2013 to December 31, 2013, and keep the associated demand with the original date, and fill in zero for the rest.

How do I do this? I have researched a few ideas, but no luck. I appreciate the help.


Thank you!