From LibreOffice Help
Jump to: navigation, search


NUMSETMANA_OOO calcula el número de setmana de l'any per a un valor de data intern.

Note.png This function exists for interoperability with LibreOffice releases older than 5.1.0 and 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.


NUMSETMANA(Nombre; Mode)

Nombre és el número intern de la data.

Mode estableix el començament de la setmana i el tipus de càlcul.

1 = Diumenge

2 = dilluns (ISO 8601)

qualsevol altre valor = dilluns (ISO 8601)


=WEEKNUM_OOO(DATE(1995;1;1);1) returns 1

=NUMSETMANA(DATA(1999;1;1);21) retorna 53. Si la setmana 1 comença el dilluns,1999-01-04.