Hello,
what is the formula to get the week number of a given date ?
TIA
Hello,
what is the formula to get the week number of a given date ?
TIA
You have two functions : WEEKNUM and WEEKNUM_EXCEL2003
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.