how to fill a gap in dates in a excel table, dates in the first column and data in the second table
Fill in gap between dates in a table I have table with several dates in a column and numbers in another. I want to fill the gap between the missing days using weekdays only, and repeat the number on each of the dates already available in the date column. How do I do this? Thanks Here is the table to fill Date Value 6/30/1980 1 12/12/1980 0 12/26/1980 1 1/8/1981 0 2/9/1981 1 6/22/1981 0