# 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

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?????

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

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.

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,

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?

7. ## Re: Week Number Calculation

Is this what you wanted?

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

8. Try this:

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

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

10. ## Re: Week Number Calculation

You're welcome and thanks for the rep.

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.

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)  ```

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1