Change date to Day Name
 

I have been using the formula '=TEXT(B17,"dddd")' in cell A17, where the date
is in cell B17. I want show the Date as a weekday in Cell A17. This was
working fine but for some reason it has stopped updating when a new date is
inserted, however if I click on the fx (insert formula) button it shows the
correct day, click ok and the cell is updated with the correct day, change
the date and it remains the same until you repeat the clicking the fx
button!!! Please Help

Change date to Day Name
 

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Belly" wrote in message
...
I have been using the formula '=TEXT(B17,"dddd")' in cell A17, where the
date
is in cell B17. I want show the Date as a weekday in Cell A17. This was
working fine but for some reason it has stopped updating when a new date
is
inserted, however if I click on the fx (insert formula) button it shows
the
correct day, click ok and the cell is updated with the correct day, change
the date and it remains the same until you repeat the clicking the fx
button!!! Please Help