Days Changing - Automatic

[asksign]

Hi,

I have an data with dates like "12.10.2018" and i need the day for that date and it should automatically change when the date changes.

 

[lrobbo314]

How about

=CHOOSE(WEEKDAY(DATEVALUE(SUBSTITUTE(A1,".","/"))),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")

 

[asksign]

Hi,

I have tried this formula, but it didn't helped me. Please help me to solve this problem.
I have typed the formula as mentioned below:
CHOOSE(WEEKDAY(DATEVALUE(SUBSTITUTE(C6,".","/"))),"Sun","Mon","Tue","Wed","Thu","Fri","Sat")
The result is #VALUE !