Week number

[shruthitulsi]

Hi,

I need to have a lookup table of past ten years, with week numbers in next column. the problem is how do i arrange the table dynamically deciding on whether it has 52 weeks or 53 weeks?

have attached the worksheet, have also given an example how the usage of table is.

Kindly help me out




Thanks & Regards,
Shruthi

[Rahul Nagar]

Hi Shruthi,

There is no any 53 week in one year
Yes there is actually a week 53, it's called a leap week, and happens approximately 71 times in 400 years.

[arthurbr]

If you want to count weeks you will first have to define in which manner you define week 1

Have a look at this page for different possibilities, and decide which system you want to use