09-24-2008 11:39 AM
Hi All,
Can anyone pls give me the function module to find the number of fiscal weeks in the given year.
Thanks,
Rajani.
09-24-2008 11:57 AM
09-24-2008 11:57 AM
09-24-2008 12:00 PM
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.
09-24-2008 12:02 PM
Hi
Fiscal years vary between businesses and countries.
[check this|http://financial-education.com/2007/02/14/the-5253-week-fiscal-year/]
Regards
Pavan
09-24-2008 12:03 PM
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.
09-24-2008 12:07 PM
>
> A leap year has only one day difference compared to other.
But number of weeks can be change
Cheers
09-24-2008 12:08 PM
If that one day falls into next week. it would increment to no of weeks.
Thanks,
Rajani.
09-24-2008 12:23 PM
>
> 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)
09-24-2008 12:25 PM
09-24-2008 12:33 PM
> 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...
09-24-2008 12:41 PM
> > 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
09-24-2008 1:30 PM
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!
09-24-2008 3:20 PM
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.