LibreOffice 7.4 Help
Π€ΡΠ½ΠΊΡΠΈΡ WEEKNUM Π²ΡΡΠΈΡΠ»ΡΠ΅Ρ Π½ΠΎΠΌΠ΅Ρ Π½Π΅Π΄Π΅Π»ΠΈ Π² Π³ΠΎΠ΄Ρ Π΄Π»Ρ Π²Π½ΡΡΡΠ΅Π½Π½Π΅Π³ΠΎ Π·Π½Π°ΡΠ΅Π½ΠΈΡ Π΄Π°ΡΡ.
This function exists for interoperability with LibreOffice releases older than 5.1.0 and OpenOffice.org. It calculates week numbers for a week numbering system in that week number 1 is the week that contains the January 4th. This function does not provide interoperability with other spreadsheet applications. For new documents use the WEEKNUM or ISOWEEKNUM function instead.
WEEKNUM(Π§ΠΈΡΠ»ΠΎ; Π Π΅ΠΆΠΈΠΌ)
ΠΡΠ³ΡΠΌΠ΅Π½Ρ ΡΠΈΡΠ»ΠΎ: ΡΡΠΎ Π²Π½ΡΡΡΠ΅Π½Π½Π΅Π΅ Π·Π½Π°ΡΠ΅Π½ΠΈΠ΅ Π΄Π°ΡΡ.
ΠΡΠ³ΡΠΌΠ΅Π½Ρ ΡΠ΅ΠΆΠΈΠΌ ΡΡΡΠ°Π½Π°Π²Π»ΠΈΠ²Π°Π΅Ρ Π½Π°ΡΠ°Π»ΠΎ Π½Π΅Π΄Π΅Π»ΠΈ ΠΈ ΡΠΈΠΏ Π²ΡΡΠΈΡΠ»Π΅Π½ΠΈΠΉ.
1 = Π²ΠΎΡΠΊΡΠ΅ΡΠ΅Π½ΡΠ΅
2 = Monday (ISO 8601)
any other value = Monday (ISO 8601)
=WEEKNUM_OOO(DATE(1995;1;1);1) returns 1
=WEEKNUM_OOO(DATE(1995;1;1);2) returns 52. Week 1 starts on Monday, 1995-01-02.
ORG.LIBREOFFICE.WEEKNUM_OOO