Date not formatted properly

Can someone help me with this code. It works fine, that's not the issue. The issue is that it is putting my date as a text format and causing further issues.
Near the bottom I have listed the exact line that is causing the issues and I don't know how to change the code to format it differently.

Please Login or Register  to view this content.

Specifically this line

Please Login or Register  to view this content.

So that it can be properly formatted as a date instead of text




I have this in another forum on this site that has been ongoing for quite sometime with user rorya but she went offline and this is urgent for me.
https://www.excelforum.com/excel-pro...es-help-2.html this is the other post that has been ongoing. If someone can help me I will make sure to close them out

Thank you so much in advance

Thank you so much