This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@Thableaus sometimes the obvious ones are correct!
@UmarS One thing to watch out for is that the %W assumes that the week starts on Monday. This could throw you off by another week if your "week" starts on Sunday and January first is a Sunday. This happened in 2017. Note that I'm using Thableaus "+1" week calculation