Ithiphu esheshayo: AmaSpredishithi e-Google namaviki ekhalenda

Lapho ukhipha amaviki ekhalenda ngosuku oluthile, kufanele uqaphele ku-Google AmaSpredishithi (njengakwi-Microsoft Excel). Umsebenzi = IKHALENDA LESONTO (NAMUHLA ()) linquma kusetshenziswa isilinganiso esijwayelekile saseMelika, lapho usuku lokuqala lonyaka luhlala lunikezwa isonto lekhalenda 1. Lokhu kuchazwa ngokuhlukile eJalimane: Lapha isonto lekhalenda lokuqala yisonto lapho okungenani izinsuku ezi-4 ziwela onyakeni omusha. Ku-Google AmaSpredishithi ungaxazulula inkinga (ngokungezelela kokunye, ezinye izindlela ezijabulisayo njenge = SHORTEN ((TODAY () - DATE (YEAR (TODAY () - REST (TODAY () - 2; 7) +3); 1; REST (TODAY ( ) -2; 7) -9)) / 7) kanye ne- modified = IKHALENDA IVIKI (NAMUHLA (); 21) ) kalula ngomsebenzi owenzelwe ngokukhethekile = ISOWEEKNUM (TODAY ()) .


Emuva