Dear Experts
Anybody can help me on how to get the week no of the current year (date), Please note that when the current year-end we need to start the new year by week no (1), thank you in advance.
e.g.:
Date Week no
2015-01-08 2
2015-01-16 3
2016-01-16 3
,...etc
Solved! Go to Solution.
What is the " +1 " doing in the formula?
Thank you,
Jim