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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Drag down not generating correct results?
- Thread starter crk317
- Start date
Similar threads
- Solved
