# Week Number Calculation

1. ## Week Number Calculation

Dear Experts,

Please find here attached workbook, where in the column R i have used the formula for Week Number calculation and result was Week 53 from column A then i have used IF condition and changed from Week 53 to Week 1 and the second issue which i am facing is the current formula is also making quite big size and working very slow for the results. Request to you kindly do provide on the both the issues.

Thank you for your precious phase and valuable support.

Regards,

Neilesh  Register To Reply

2. ## Re: Week Number Calculation

This is shorter.

="Week "&WEEKNUM(A2)&", "&J2

I got a bit confused by your week 53 issue... Do you want Week 1 to be extended by the days in week 53 of the previous year?????  Register To Reply

3. ## Re: Week Number Calculation Originally Posted by Glenn Kennedy This is shorter.

="Week "&WEEKNUM(A2)&", "&J2

I got a bit confused by your week 53 issue... Do you want Week 1 to be extended by the days in week 53 of the previous year?????
Dear Expert,

Thank you so much for your precious phase. But we are considering first week from Jan.04 (Which will starting from Monday) to Jan 10 2016 (Ending at Sunday) and Week 52 will be Dec.26 to Jan.01, 2017.

I have tried the provided formula as well but the result throwing as Week 53. Request to you please do help me out.

Regards,

Neilesh

Regards,

Neilesh  Register To Reply

4. ## Re: Week Number Calculation

=INT((A1-42373)/7)+1

where A1 is a 2016 date from 04/01/2016 onwards provides the week number from 1 to 52.  Register To Reply

5. ## Re: Week Number Calculation Originally Posted by Special-K =INT((A1-42373)/7)+1

where A1 is a 2016 date from 04/01/2016 onwards provides the week number from 1 to 52.
Dear Expert,  Register To Reply

6. ## Re: Week Number Calculation

Week 1 begins on the FIRST Monday of the year. Yes or no? If no: when does it start.

In 2016, the first Monday was the 4th. What week/Year should Sunday 3rd January 2016 have?  Register To Reply

7. ## Re: Week Number Calculation

Is this what you wanted?

="Week "&IF(WEEKNUM(A2,21)>52,1,WEEKNUM(A2,21))&" of "&YEAR(A2)  Register To Reply

8. Try this:

=IF (DATE (A1),1,4),52, INT ((A1-DATE (YEAR (A1).1.4))/7+1)  Register To Reply

9. ## Re: Week Number Calculation Originally Posted by Glenn Kennedy Is this what you wanted?

="Week "&IF(WEEKNUM(A2,21)>52,1,WEEKNUM(A2,21))&" of "&YEAR(A2)
Thank you Dear Expert. Yes i was looking for the same Dear Expert.

Regards,

Neilesh  Register To Reply

10. ## Re: Week Number Calculation

You're welcome and thanks for the rep.  Register To Reply

11. ## Re: Week Number Calculation Originally Posted by Neilesh Kumar Dear Expert,

That's impossible, since whatever the formula does, 1 is then added to the final result.
So it can never be 0.

However, sounds like you have a solution.  Register To Reply

12. ## Re: Week Number Calculation

HTML Code:
``=if(a1 <  date(year(a1),1,4),52,int((a1-date(year(a1),1,4))/7)+1)``
PHP Code:
``` =if(a1 <  date(year(a1),1,4),52,int((a1-date(year(a1),1,4))/7)+1)  ```  Register To Reply