Formula to get week number ?

[Venaissin]

Hello,

what is the formula to get the week number of a given date ?

TIA

[jbfaure]

You have two functions : WEEKNUM and WEEKNUM_EXCEL2003

https://help.libreoffice.org/6.0/en-US/text/scalc/01/func_weeknum.html?System=UNIX&DbPAR=CALC#bm_id3158403

https://help.libreoffice.org/6.0/en-US/text/scalc/01/func_weeknumadd.html?System=UNIX&DbPAR=CALC#bm_id3166454

[Lupp]

Use ISOWEEKNUM(theDate). It’s the only reliable function applying a clearly defined standard and without standard-breaking additional parameters.
The ISO 8601 standard: ISO week date - Wikipedia
(Week numbering is mainly used in business and administration. Doing it without a strict standard is useless.)

Edit:
AOO still has not implemented this function. (It’s a shame.)
I don’t know what recent Excel offers. Most likely it will not be reasonable.