How to fill in missing date rows in an Excel spreadsheet?

[Mr. Snrub]

My Excel spreadsheet looks like the following:

Date	Close
12/31/2015​	5007.41​
1/4/2016​	4903.09​
1/5/2016​	4891.43​
1/6/2016​	4835.76​
1/7/2016​	4689.43​
1/8/2016​	4643.63​
1/11/2016​	4637.99​
1/12/2016​	4685.92​
1/13/2016​	4526.06​
1/14/2016​	4615​
1/15/2016​	4488.42​
1/19/2016​	4476.95​
1/20/2016​	4471.69​

...and I want it to look like this:

Date	Close
12/31/2015​	5007.41​
1/1/2016​	5007.41​
1/2/2016​	5007.41​
1/3/2016​	5007.41​
1/4/2016​	4903.09​
1/5/2016​	4891.43​
1/6/2016​	4835.76​
1/7/2016​	4689.43​
1/8/2016​	4643.63​
1/9/2016​	4643.63​
1/10/2016​	4643.63​
1/11/2016​	4637.99​
1/12/2016​	4685.92​
1/13/2016​	4526.06​
1/14/2016​	4615​
1/15/2016​	4488.42​
1/16/2016​	4488.42​
1/17/2016​	4488.42​
1/18/2016​	4488.42​
1/19/2016​	4476.95​
1/20/2016​	4471.69​

So basically if the next row is not one day later than the current row, then add a new row with the current row's price until the next row's date matches. How do I do this?

 

[billszysz]

Próbka na forum.xlsx
	A	B	C	D	E	F	G	H
1		Date	Close			Date	Close
2		2015-12-31	5007,41			2015-12-31	5007,41
3		2016-01-04	4903,09			2016-01-01	5007,41
4		2016-01-05	4891,43			2016-01-02	5007,41
5		2016-01-06	4835,76			2016-01-03	5007,41
6		2016-01-07	4689,43			2016-01-04	4903,09
7		2016-01-08	4643,63			2016-01-05	4891,43
8		2016-01-11	4637,99			2016-01-06	4835,76
9		2016-01-12	4685,92			2016-01-07	4689,43
10		2016-01-13	4526,06			2016-01-08	4643,63
11		2016-01-14	4615			2016-01-09	4643,63
12		2016-01-15	4488,42			2016-01-10	4643,63
13		2016-01-19	4476,95			2016-01-11	4637,99
14		2016-01-20	4471,69			2016-01-12	4685,92
15						2016-01-13	4526,06
16						2016-01-14	4615
17						2016-01-15	4488,42
18						2016-01-16	4488,42
19						2016-01-17	4488,42
20						2016-01-18	4488,42
21						2016-01-19	4476,95
22						2016-01-20	4471,69
23
Arkusz2

Cell Formulas
Range	Formula
F2:F22	F2	=SEQUENCE(MAX(B2:B14)-MIN(B2:B14)+1,,MIN(B2:B14),1)
G2:G22	G2	=XLOOKUP(F2#,B2:B14,C2:C14,"",-1,2)
Dynamic array formulas.