Fill in missing dates and repeat data in adjacent column

[Excel for jpf]

HI, How do i fill the missing dates and repeat the value in the second column. Thank you

Date	Value
1979-02-08	0
1979-02-28	1
1979-03-09	0
1979-04-24	1
1979-05-08	0

 

[p45cal]

In the attached, Sheet1 (2), 2 solutions. First make your source data into a proper Excel table, then:
1. Power Query at cell D1. When the data in the source table changes, right-click the green table and choose Refresh.
2. Formula only in cells I2 & J2.

 

[bosco_yip]

Try,

1] In "Date" D2, formula copied down until blank :

=IF(ROW(A1)<=A$10-A$2+1,A$2-1+ROW(A1),"")

2] In "Value" E2, formula copied down until blank :

=IF(D2="","",INDEX(B:B,MATCH(D2,A:A)))

Or,

=IF(D2="","",LOOKUP(D2,A:B))