1) Get the full date for 2015 by adding this formula in column L (starting in cell L1)and copying all the way down to the last used row:

**=UPPER(TEXT(IF(K1<>"",DATE**VALUE(H1&" "&J1&", "&K1+1),""),"DDDD, MMMM D, YYYY"))

Since your sheets are identically laid out, you can apply this to the first sheet, then select all the formulas in column L and copy them to the other two sheets in column L also.

2) convert all these formulas to values. Copy all the formulas, and use PasteSpecial - Values to paste them in place (again, in column L).

3) Delete all the values in columns F:K

4) Copy all the values in column L and paste (values only) in column K. Change the alignment to right-align so that the full date will appear completely in the grey row.

5) Delete column L.

I've applied this to your example workbook for you to see.

Regards,

-Glenn

EE-Conference-Rooms-2015-Qtr-1.xlsx