Ingcebiso ekhawulezileyo: AmaSpredishithi eGoogle kunye neeVeki zeKhalenda

Xa ukhupha iiveki zekhalenda kumhla othile, kuya kufuneka ulumke kwiiSpredishithi zikaGoogle (nje ngeMicrosoft Excel). Umsebenzi = IVEKI YEKHALENDA (NAMHLANJE ()) ubala ngokusebenzisa umgangatho waseMelika, osoloko unikwa usuku lokuqala lonyaka kwikhalenda yeveki yoku-1. Oku kuchazwa ngokwahlukileyo eJamani: Nantsi iveki yekhalenda yokuqala evekini apho ubuncinci iintsuku ezi-4 ziwela kunyaka omtsha. KuGoogle AmaSpredishithi ungayisombulula ingxaki (phakathi kwezinye, iindlela ezinomdla ezinje = -2; 7) -9)) / 7) kunye ne = modified IVEKI YEKHALENDA (NAMHLANJE (); 21) ) ngokulula ngomsebenzi owenziwe ngokukodwa = ISOWEEKNUM (NAMHLA ()) .


Emva