With
A1 containing your source text
This regular formula returns the number of days remaining until the embedded date plus 40 days
B1: =(TEXT(MID(B1,FIND("-",B1)+1,8),"00-00-0000")+40)-TODAY()
Is that something you can work with?