Forum Discussion
Tracy899
Dec 10, 2020Copper Contributor
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.
1 Reply
Sort By
- RobElliottSilver Contributor
Tracy899 you don't need WEEKDAY in the formula, just use =TEXT(Expiration,"ddd")
Rob
Los Gallardos
Microsoft Power Automate Community Super User