NRO.SEMAJNO.OOO

NRO.SEMAJNO.OOO kalkulas la numeron de la semajno en la jaro por la interna data valoro.

Note Icon

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.


Sintakso

NRO.SEMAJNO.OOO(numero; reĝimo)

Number is the internal date number.

Mode sets the start of the week and the calculation type.

1 = Sunday

2 = Monday (ISO 8601)

any other value = Monday (ISO 8601)

Ekzemploj

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

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