Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
=TEXT(L2,"DDDD")
in the cell where the week-day-name is shown (ie. F1, F42, etc.). And I placed in column L every date for January 2015. So formatting column L as Date then placing 1/1/2015 in L1, and 1/2/2015 in L2, etc. (stretch the pattern down for 31 days) gives me each day of the month. Note: you don't need to use column L, if you'd rather have it hidden somewhere. Then, that tiny formula above does the trick. You'll just need to copy the formula text and paste it in each F cell and change L1 to L2 then L3 and L4, etc.=UPPER(TEXT(DATEVALUE(H1&" "&J1&", "&K1), "dddd"))
This will calculate the day name using the date info given.
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
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