Instead, you could indicate to Excel to display the day of the week for a date within another cell. If you change the date, Excel will then update the calculation.