I can't understand why you would need both, TEXT("dddd") and WEEKDAY() when
one does very well.
Perhaps there are issues with extra characters. Try the TRIM() function, and
format numbers as general to see if it yields a value somewhere around 39,000