Format date within formula in VBA

[JenaB]

Thanks, Paul. I rarely work with WorkSheet Formulas in VBA

Thanks for the attempt SamT but I didn't have any success with your suggestions. Just for closure, I was able to get this to work: Range("P2") = "=TEXT(A2,""mmddyyyy"")&E2&O2"