Welcome to the forum!

Did you want a formula or VBA? Mid() would be used in both. Where is the day in that or is day 1 sufficient?

Click the Go Advanced button in lower right of a reply, and scroll down to Manage Attachments to browse and upload a file if needed.