=SUM($D$3:INDEX(D:D, ROW()-1))+1&"-"&N(SUM($D$3:INDEX(D:D, ROW())))

=--TEXT(SUBSTITUTE(F3,".","/"),"YYYYMMDD")