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