Weekday shows the wrong day

[GK039]

Hello everybody,

Back again after sooo long

I am facing a problem with the weekday function that after a bit of googling I saw that is a common question but I couldn't find an answer.

Say in cell A1 there is the date 10-01-2019 which is a Thursday

=weekday(A1,1) gives a 5 (correct). Applying custom formatting "dddd" is a Thursday (correct)

but

=weekday(A1,2) gives a 4 (correct). Applying custom formatting "dddd" is a Wednesday (false)

Could you explain me the logic behind this behavior and how to overcome this?

PS: I changed at the region settings the "First Day of week" text box to be a Monday but still doesn't work

Thank you!
George

 

[Scott Huish]

Weekday doesn't return a date, so I don't quite get why you are formatting it as a date format (dddd)

The logic is dates are just numerical sequences starting from Jan 1, 1900. So 5 would be January 5, 1900 Thursday, while 4 would be Janary 4, 1900 Wednesday.

So the question is what are you trying to accomplish exactly?

 

[GK039]

Weekday doesn't return a date, so I don't quite get why you are formatting it as a date format (dddd)

The logic is dates are just numerical sequences starting from Jan 1, 1900. So 5 would be January 5, 1900 Thursday, while 4 would be Janary 4, 1900 Wednesday.

So the question is what are you trying to accomplish exactly?

Hello Scott,

Thank you for your answer. As far as the logic part is concerned its clear now, thanks.
What I am trying to accomplish is to get the weekday out of a date and show the day in text format, which also the

 =TEXT(WEEKDAY(A1,2),"dddd")

doesn't seem to do it.

George

 

[Rick Rothstein]

Hello Scott,

Thank you for your answer. As far as the logic part is concerned its clear now, thanks.
What I am trying to accomplish is to get the weekday out of a date and show the day in text format, which also the

 =TEXT(WEEKDAY(A1,2),"dddd")

doesn't seem to do it.

You do not need to use the WEEKDAY function as the TEXT function can work with dates directly. Try it this way...

=TEXT(A1,"dddd")

 

[GK039]

You do not need to use the WEEKDAY function as the TEXT function can work with dates directly. Try it this way...

=TEXT(A1,"dddd")

Thank you Rick. I thought the TEXT function could work in conjunction with the WEEKDAY function as well.
It's clear now.
George