in C2 i have the below formula which pulls the sheets name (a date) and inserts it into the cell. Example "01-01-17"
I want the above cell (C1) to display the day of the date that is in cell C2 (example "Thursday")
When i enter "=C2" into cell "C1" the date enters correctly. When i then try to format the cell or use conditional formatting to make the date display as a day (ddd) it doesn't work. It just keeps displaying the date.
Any ideas?
Sample: http://www.excelforum.com/attachment...1&d=1481777893
Bookmarks