how to get weekday ?

[ks1102]

hi , expects
how to get weekday base on those format 09/07/2013 to come out = SAT ? i had trying formula as

=CHOOSE(WEEKDAY(Q3),"SUN","MON","TUE","WED","THU","FRI","SAT")

but wrongly shown me TUE ?

[ragulduy]

I'm guessing, that weekday is interpreting your date as the 9th of July, which was a Tuesday, rather than the 7th September?
Maybe try using date(year,month,day) to make sure the date is correct?

[ks1102]

I'm guessing, that weekday is interpreting your date as the 9th of July, which was a Tuesday, rather than the 7th September?
Maybe try using date(year,month,day) to make sure the date is correct?

But the format was prefixed data come for data source with huge at spread sheet!! do any way can i correct it to what i want ?

[Fotis1991]

Also you can get same result using:

=Q3

Format this cell as: ddd

[Fotis1991]

We suspect that Your data are in this format

mm/dd/yyyy

Change to:

dd/mm/yyyy

[Fotis1991]

I see that you marked your thread as solved. Well done!

The feedback is always appreciated from the people that helped you to find your solution.

[:) Sixthsense :)]

Or

=TEXT(Q3,"DDD")