how to get weekday ?

Originally Posted by yudlugar

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 ?