Can't get the serial dates to convert to formatted dates.

  • 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.

  • Re: Can't get the serial dates to convert to formatted dates.


    Hi Maqbool,


    Thanks for the quick reply. I tried the formula and it worked!



    Sincerely
    jledlow

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!