Forum Discussion

Tracy899's avatar
Tracy899
Copper Contributor
Dec 10, 2020

Need help on text function formula

I have created a calculated column in my sharepoint list . I want to show the day name as Fri or Friday. 

 

Column name: Date (Format: Date& time)

Column name: Day (Column type: Calculated and fomula: =TEXT(WEEKDAY([Date]), "dddd") , but it return error when I save it. 

 

If I do formula:  =(WEEKDAY((Date)), it allows me to create the column and the return value will be in number.  example date: 1/1/2021 return result 6 which is means of Saturday. My question is how can I change this number value to be text show as Saturday? Pls advise what is the formula. 

Resources