Hi, I am using the formula =TEXT(*cell reference*,"dddd") to display the date in the cell reference (in format xx/xx/xxxx) as its corresponding day of the week. It works great when I manually type it in, but when I try to drag down the formula to other cells, it is just displaying the day of the...