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 week of the cell that I dragged down from. But when I click one of the cells, it contains the correct formula, but is just not displaying the right output. How would I fix this? Thank you.