Thread: [Solved] Concatenate text and a date
View Single Post
 
Old 11-15-2018, 07:52 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default Concatenate text and a date

Hi all

I am trying to concatenate the following, but I can't get my formula to work correctly.

In cell AC3 - the words "Installation"
In cell AF3 - is the installation date
In cell AH3 - the words " Warranty Expires"
In cell AK3 - is the expiration date

Can someone please help me with the correct formula as my dates are appearing as numbers.

Many thanks
Reply With Quote