Hello
Cell F1 contains a date entered by a user, say 15/09/15
Cell C1 has a formula to give the day of the week =TEXT(F1,"DDD")
which gives me Tuesday, however I want TUESDAY in all capitals. I know there is a formula command UPPER but I'm not sure where it goes and several attempts haven't given me what I wanted.
Many thanks
thank you for helping
____________
Pendle
Cell F1 contains a date entered by a user, say 15/09/15
Cell C1 has a formula to give the day of the week =TEXT(F1,"DDD")
which gives me Tuesday, however I want TUESDAY in all capitals. I know there is a formula command UPPER but I'm not sure where it goes and several attempts haven't given me what I wanted.
Many thanks
thank you for helping
____________
Pendle