date not recognized
If I leave out the "dddd" the result is a number- Looks like the number 1 for
Sunday, 2 for Monday and so on... I don't know what the TRIM function is?
"Tevuna" wrote:
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
|