ʻ Tiplelo Aʻoaʻo wikiwiki: Nā Pepa Google a me nā Weke Alemanaka

Ke hoʻopuka nei i nā pule kalena ma kahi lā kikoʻī, pono ʻoe e akahele i nā Google Sheets (e like me Microsoft Excel). ʻO ka hana = CALENDAR WEEK (TODAY ()) i ka helu ʻana me ka hoʻohana ʻana i ka hae ʻAmelika, kahi e hāʻawi mau ʻia ai ka lā mua o ka makahiki i ka wiki kalena 1. Ma Kelemania ua wehewehe ʻokoʻa kēia: Eia ka hebedoma kalena mua ka hebedoma kahi e hāʻule ai ma kahi o 4 mau lā i ka makahiki hou. I nā Pepa Google hiki iā ʻoe ke hoʻoponopono i ka pilikia (me nā koho ʻē aʻe hoihoi e like me = SHORTEN ((TODAY () - DATE (YEAR (TODAY () - REST (TODAY () - 2; 7) +3); 1; REST (TODAY ( ) -2; 7) -9)) / 7) a me ka hoʻololi = CALENDAR WEEK (TODAY (); 21) ) maʻalahi me ka hana i hoʻomākaukau ʻia = ISOWEEKNUM (KĀNĀ ()) .


Hope