Displaying 1 result from an estimated 1 matches for "dcrzen".
2009 Dec 11
1
Calendar week ISO (PR#14132)
...tting the calendar
week number with the first week as the one which has at least 4 days. A
colleague told me that he has the same problem.=20
=20
Below you can see what I use now, for finding the right week.=20
=20
=20
Kind regards,=20
Samuel Andreas Meichtry
=20
=20
#Excel-Funktion
#=3DK=DCRZEN((A3-DATUM(JAHR(A3+3-REST(A3-2;7));1;REST(A3-2;7)-9))/7)
=20
=20
#R-Funktion
KW<-function(x){=20=20=20=20
return(floor(
as.numeric((x-(as.Date(ISOdate(
=20
as.numeric(format(as.Date(as.numeric(x)+3+25569-2-(as.numeric(x)-2+25569)%%7
,origin=3D"1900-01-01"),"%Y")...