13 periods in a year gives periode 14

[DB73]

Hi peeps,

i'm trying to solve a little problem

i use the following formula to get a period number from a date;

=ALS.FOUT(INTEGER(([@[Wk nr.]]+3)/4);"")

in english; =IFERROR(INT......

i want just 13 periods but it gives 14

do i need another formula, maybe from colomn A, from a date, or just adjust my formula?

I've been searching for a couple of hours on the big www and tried other formulas which i could find, but it didn't seems to work for me.
maybe someone got a solution for me..

i think its because it gives week 53 in colomn J, which normaly should be week 52.
apparently some years have 53 weeks
i use this formula for that;

=ISO.WEEKNUMMER([@Datum])

i also tried ;

=WEEKNUMMER([@Datum];1)

then Januari is correct but December gives still period 14

thanks in advance

 

[aaewalsh]

Try This

=ALS.FOUT(INTEGER(([@[Wk nr.]]-1+3)/4);"")

 

[DB73]

Try This

=ALS.FOUT(INTEGER(([@[Wk nr.]]-1+3)/4);"")

also doesnt seems to work.
now period 14 is "0"

 

[Fluff]

What period should wk53 be?
If it should be 13 then how about

=MIN(INT(([@[Wk nr.]]-1)/4)+1,13)