Hi,
i am using a calendar in Excel and Libreoffice. And the problem is that the function =WEEKDAY(number;type) seems different.
If I use f.e. =WEEKDAY(A4;2) in Excel i get “00002”
in Libreoffice i get “00001”
In this case [A4] = Tuesday
Do you have any solutions?
What does it mean? Does [A4] contain a string “Tuesday”? Or something else?
A sample spreadsheet showing the problem is better than a thousand words.
I’m picking both cells look the same but one of cells is English (US) and the other is English (UK) or similar. English (US) 1/3/22 [3-Jan-22] returns 1, English (UK) 1/3/22 [1-Mar-22] returns 2
How Excel returns wrong dates with wrong weekdays for all day numbers between 1 and 60 and why Calc’s zero day is 1899-12-30: Leap_Year_Bug.ods (30.3 KB)
Excel’s WEEKDAY is wrong with all numbers between 1 and 60.
However, for those dates, the difference would be the opposite: e.g., 1900-01-02 (which is Serial Date 3 in Calc, and Serial Date 2 in Excel by default) would give 2 in Calc vs. 1 in Excel 
For some reason you find WEEKDAY(X1;2) in many Excel documents where X1 is a day number between 1 and 31. By mere chance, the output of this dummy operation is the same as the input.
I assume you meant ;1 - otherwise, the result would not be the same as the input.
But in this case, output of Calc would agree with that of Excel: e.g., WEEKDAY(3;1) is 3 both in Calc and in Excel (and the difference is that 3 means different dates in the two applications).