Forum Discussion
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...
As variant you may add another 'calendar' column from minimum date to maximum or newer (e.g. by autofill) and another column for values as here