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

%3CLINGO-SUB%20id%3D%22lingo-sub-958886%22%20slang%3D%22en-US%22%3Ehow%20to%20fill%20a%20gap%20in%20dates%20in%20a%20excel%20table%2C%20dates%20in%20the%20first%20column%20and%20data%20in%20the%20second%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-958886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3E%3CU%3EFill%20in%20gap%20between%20dates%20in%20a%20table%3C%2FU%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20have%20table%20with%20several%20dates%20in%20a%20column%20and%20numbers%20in%20another.%20I%20want%20to%20fill%20the%20gap%20between%20the%20missing%20days%20using%20weekdays%20only%2C%20and%20repeat%20the%20number%20on%20each%20of%20the%20dates%20already%20available%20in%20the%20date%20column.%20How%20do%20I%20do%20this%3F%20Thanks%3C%2FP%3E%3CP%3EHere%20is%20the%20table%20to%20fill%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%3CP%3EDate%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3EValue%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E6%2F30%2F1980%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E12%2F12%2F1980%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E12%2F26%2F1980%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E1%2F8%2F1981%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E2%2F9%2F1981%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E1%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%3CP%3E6%2F22%2F1981%3C%2FP%3E%3C%2FTD%3E%3CTD%3E%3CP%3E0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-958886%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efill%20hndle%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-997680%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20fill%20a%20gap%20in%20dates%20in%20a%20excel%20table%2C%20dates%20in%20the%20first%20column%20and%20data%20in%20the%20second%20t%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-997680%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F61169%22%20target%3D%22_blank%22%3E%40Jean-Pierre%20Fruchet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20you%20may%20add%20another%20'calendar'%20column%20from%20minimum%20date%20to%20maximum%20or%20newer%20(e.g.%20by%20autofill)%20and%20another%20column%20for%20values%20as%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20513px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155960i9DB2FF6D3050ECBF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

1 Reply

@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

image.png