NRO.SEMAJNO

NRO.SEMAJNO kalkulas la numeron de la semajno en la jaro por la interna data valoro kiel difinita en ODF OpenFormula kaj kongrua kun aliaj kalkultabelaj aplikaĵoj.

Supported are two week numbering systems:

System 1: The week containing January 1 is the first week of the year, and is numbered week 1.

System 2: The week containing the first Thursday of the year is the first week of the year, and is numbered week 1. That means that week number 1 of any year is the week that contains January 4th. ISO 8601 defines this system and that the week starts on Monday.

Sintakso

NRO.SEMAJNO(numero [; reĝimo])

Number is the internal date number.

Mode sets the start of the week and the week numbering system. This parameter is optional, if omitted the default value is 1.

1 = Sunday, system 1

2 = Monday, system 1

11 = Monday, system 1

12 = Tuesday, system 1

13 = Wednesday, system 1

14 = Thursday, system 1

15 = Friday, system 1

16 = Saturday, system 1

17 = Sunday, system 1

21 = Monday, system 2 (ISO 8601)

150 = Monday, system 2 (ISO 8601, for interoperability with Gnumeric)

Ekzemploj

=NRO.SEMAJNO(DATO(1995;1;1);1) liveras je 1

=NRO.SEMAJNO(DATO(1995;1;1);2) liveras je 52. Se la semajno komencas je lundo, dimanĉo apartenas al la lasta semajno de la antaŭa jaro.

=NRO.SEMAJNO(DATO(1995;1;1);21) liveras je 52. Semajno 1 komencas je lundo, 1995-01-02.

=NRO.SEMAJNO(DATO(1999;1;1);21 liveras je 53. Semajno 1 komencas je lundo, 1999-01-04.