Ask Your Question
0

Formula to get week number ?

asked 2018-08-06 08:14:07 +0200

Venaissin gravatar image

Hello,

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

TIA

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2018-08-06 09:06:30 +0200

JBF gravatar image

You have two functions : WEEKNUM and WEEKNUM_EXCEL2003

https://help.libreoffice.org/6.0/en-U...

https://help.libreoffice.org/6.0/en-U...

edit flag offensive delete link more
0

answered 2018-08-06 09:22:13 +0200

Lupp gravatar image

updated 2018-08-06 10:19:10 +0200

Use ISOWEEKNUM(theDate). It's the only reliable function applying a clearly defined standard and without standard-breaking additional parameters.
The ISO 8601 standard: https://en.wikipedia.org/wiki/ISO_wee...
(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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-06 08:14:07 +0200

Seen: 77 times

Last updated: Aug 06 '18