| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Threaded Mode
