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

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

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,

Thank you for your precious support but the throwing result is 0. Request to you please help me out.

Try this:

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

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

HTML Code: 

PHP Code: 

=if(a1 <  date(year(a1),1,4),52,int((a1-date(year(a1),1,4))/7)+1)