Need help on text function formula

[Tracy899]

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. 

[#2]

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

Rob
Los Gallardos
Microsoft Power Automate Community Super User