CODEWITHSUNDEEP
excel
WeAreOne
WeAreOne

Reputation: 1343

Weekday(...) shows wrong weekday

I live in Europe. Week starts on Monday and ends on Sunday. Today is Friday, the 5th day of the week.

https://1drv.ms/x/s!AncAhUkdErOkgqR6jJ76GcWrCJozpQ?e=mRH7Ab

=Weekday(Today();2)

shows Thursday as weekday, not friday.

Why? And why shows Returntype 1 (or omitted) Friday, it should show Saturday (6th day of the week)?

And what is the difference between Returntype 2 and 11?

enter image description here

Upvotes: 0

Views: 592

Answers (1)

Rory
Rory

Reputation: 34075

WEEKDAY is returning the correct result in that cell - i.e. 5.

If you format 5 as ddd, you are actually formatting the date 5 days after 31.12.1899 which is the 5th Jan 1900, which was a Thursday.

Upvotes: 1

Related Questions