Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

FM to find the number of fiscal weeks in a year

Former Member
0 Kudos

Hi All,

Can anyone pls give me the function module to find the number of fiscal weeks in the given year.

Thanks,

Rajani.

1 ACCEPTED SOLUTION

JozsefSzikszai
Active Contributor
0 Kudos

is it not 52 all the time?

12 REPLIES 12

JozsefSzikszai
Active Contributor
0 Kudos

is it not 52 all the time?

0 Kudos

Hi Eric,

I too think the number is 52. But I want the confirmation from experts. Is it always 52 or varies ( in case of leap year etc). Can you please confirm this.

Thanks,

Rajani.

0 Kudos

Hi

Fiscal years vary between businesses and countries.

[check this|http://financial-education.com/2007/02/14/the-5253-week-fiscal-year/]

Regards

Pavan

0 Kudos

I too think the number is 52. But I want the confirmation from experts. Is it always 52 or varies ( in case of leap year etc). Can you please confirm this.

A leap year has only one day difference compared to other.

0 Kudos

>

> A leap year has only one day difference compared to other.

But number of weeks can be change

Cheers

0 Kudos

If that one day falls into next week. it would increment to no of weeks.

Thanks,

Rajani.

0 Kudos

>

> If that one day falls into next week. it would increment to no of weeks.

normal year = 365 days = 52 * 7 days + 1 day = 52 weeks + 1 day

a leap year has one day as extra (= 52 weeks + 2 days)

0 Kudos

Eric,

Did you actually enjoy 2004 ?

0 Kudos

> Eric,

>

> Did you actually enjoy 2004 ?

wasn't bad...

do you mean, there were 53 weeks in that year? because I have concern, how it is actually counted...

0 Kudos

> > Eric,

> >

> > Did you actually enjoy 2004 ?

wasn't bad...

do you mean, there were 53 weeks in that year? because I have concern, how it is actually counted...

wasn't bad... 🙂

Thats sounds Sweet

do you mean, there were 53 weeks in that year?

Yes

because I have concern, how it is actually counted...

If in a leap year fabruary falls in 5 weeks then that is the only possibility for 53 weeks

Cheers

PS:But No logic would be applied in this case

0 Kudos

thanks for the correction, but 2008 is also a leap year and there are only 52 weeks (acc. to the calendar on the wall next to me). I think it depends on which weekday is the 1st of January:

Monday: 1st week is between 1st (MON) and 7th (SUN) of Jan.

Tuesday: 1st week is between 1st (TUE) and 6th (SUN) of Jan.

Wednesday: 1st week is between 1st (WED) and 5th (SUN) of Jan.

Thursday: 1st week is between 1st (THU) and 4th (SUN) of Jan.

I think the turning point is here (a week needs to have at least 4 days):

Friday: between 1st (FRI) and 3rd (SUN) of Jan. ==> this is 0th week (or 52nd or 53rd week of last year)

Saturday and Sunday: same logic like in case of Friday

OK, let's go to the end of the year, and continue with the above grouping (1st of Jan. was):

Monday: we have 52 full weeks 1 day extra, that one day will go to next year, so 52 weeks all together

Tuesday: 52 weeks and 2 days extra (because first week has only six days), the 2 days -again- go to next year, so 52 weeks all together

Wednesday: 52 weeks + 3 days = 52 weeks

Thursday: 52 weeks + 4 days = 53 weeks

Friday: 51 weeks + 5 days = 52 weeks (pls. note we had 3 days minus here!)

Saturday: 51 weeks + 6 days = 52 weeks

Sunday: 51 weeks + 7 days = 52 weeks

In case of leap year we have one day extra, so that will make difference only when the 1st of Jan is Wednesday and will make that year with 53 weeks.

Try to make it simple:

If the first week of the year is Thursday ==> 53 weeks

If the first week of the year is Wednesday AND it is a leap year ==> 53 weeks

All other cases ==> 52 weeks

Could someone please check?

PS.: I hope the thread opener still follows!

Former Member
0 Kudos

Hi All,

Solved. The FM is TIME_GET_LAST_WEEK. It returns the last fiscal week in the year.

Pavan, Thanks for the beautiful link on 52/53 Fiscal weeks issue.

Amit, Thanks for giving an example year 2004 for 53 weeks.

Thanks All,

Rajani.