Change date to Day Name

B

Belly

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add day to PWA 2016 date format? 0
Search closest day in the past from today 2
Help with Formula... 1
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
3 Questions 16
Date Time increment with additional condition of skipping weekends 18
How to replace a constant from a cell containing date and time 1
Formula for adding a day to a particular date. 1

Top