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. 

1 Reply

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    Tracy899 you don't need WEEKDAY in the formula, just use =TEXT(Expiration,"ddd")

     

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources