Formula Correction Required

Dear Team,

There are two sheets in below attached workbook one is contains formula and second one example/ Result.

I am trying to add three star "***" before and the end of the formula.

the issue is when i enter the date in conditional formatting then it removes the stars at the end of the formula. please resolve the issue.

Book4 is the right sheet to correct the formula.

Yes combo box is VBA related issue.

Actually there are different issue occurs while making reports. this is why.