how to fill a gap in dates in a excel table, dates in the first column and data in the second table

[Jean-Pierre Fruchet]

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

[#2]

@Jean-Pierre Fruchet 

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