replacing the cell reference with your formula gives an error (Your Formula Contains an Error) and it highlights the "yyyymmdd" section as the issue

Thanks a lot!

Jon