I'm creating an employee time sheet spreadsheet. I have the dates in column b14 to b20, which are the seven days of the week, formatted correctly as mm/dd/yyyy. What I am trying to do is to have another cell display the pay period by copying the values from b14 and b20 into a single cell (g9) and displaying the values in this format "mm/dd/yyyy to mm/dd/yyyy". The formula I am using is displaying the dates as the serial date values and I cannot get it to format the dates as mm/dd/yyyy. Any help would be greatly appreciated. I have attached the spreadsheet for anyone that might need to look at it. You will see that in cell g9/h9 which have been merged, what is going on.
Spreadsheet has been removed since question was answered.