Hi.
I've been trying to turn dates e.g. 4 October 2019 into the week number of that year. The formula is working, except when the week falls on a number containing a zero, like week 30, or 40 or 50. In that case it returns the serial number of the date.
Bookmarks