Ask Your Question

Formula to get week number ?

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

Venaissin gravatar image


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


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

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

JBF gravatar image

You have two functions : WEEKNUM and WEEKNUM_EXCEL2003

edit flag offensive delete link more

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:
(Week numbering is mainly used in business and administration. Doing it without a strict standard is useless.)

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


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

Seen: 77 times

Last updated: Aug 06 '18