Problem with TEXT and weekday function

[Armator]

Hello Community,

I am having an issue with the TEXT and Weekday function.

What I would like to achieve:

• In column A I have some dates. Those dates are stored as text and formatted as "General".
• In column B I would like to transform those dates into the following format: "yyyymmdd". To achieve this I am using the following formula: =TEXT(A2,"yyyymmdd").
• In column C I would like to get the day of the week. Toa chieve this I am using the =Weekday() function.

I am getting the following results:
Capture.PNG

• Column B: Cell B3 gives me the desired outcome. Although I am using the same formula in B2, the output is just a repetition of the content of A2.
• Column C: returns a #Value and a #Num error.

I am using Office 365 and the file is a xlsx file in case this is important.