How to join three sets of code together

That code looks like the perfect example of overcomplicating code..

Replace all with

Please Login or Register  to view this content.

The formatting of the cells to show date you do once in the cell properties itself no need to set it everytime the date is replaced

also:
if you only need the date use Date.
if you need date and time use Now
if you only need time use Time (or Now - Date )