Ke ʻike nei i ka ʻikepili ma nā Pepa Google, hiki i kekahi ke hālāwai me ka pilikia ʻaʻole hiki i ka \(x\) -axis ke hoʻopihapiha i nā hakahaka i nalowale i nā waiwai huaʻōlelo (e like me nā pule kalena). I mea e hoʻonā ai i ka pilikia, hana kekahi i kahi lā mau o nā lā, helu i nā pūnaewele i loaʻa a laila ʻike ʻia nā huina hoʻohui.
ʻO ke kiʻi maʻamau, e helu ana i ka helu o nā waiwai e kū nei, aia nā hemahema i ʻōlelo ʻia (i ka laʻana o ka wiki kalena "24/2020" e nalo nei):

Inā makemake ʻoe e hana i kahi lā lā (ma waena o kahi lā hoʻomaka a me kahi lā e pili ana i kēia lā), paipai ʻia ka hoʻohana ʻana iā ARRAYFORMULA a me ZEILE:
9d60612e712ab8d9ea16e760161ff89b
Hiki ke hana i ka mea like no nā wiki kalena (a, inā pono, no ka hapaha a me nā makahiki pū kekahi):
9d60612e712ab8d9ea16e760161ff89b
Loaʻa i ka cell \(F1\) ka lā hoʻomaka a me \(F2\) ka helu o nā lā e pili ana i kēia lā. I kēia manawa, helu mākou i nā waiwai like ʻole o ka lā palena mau:
9d60612e712ab8d9ea16e760161ff89b
ʻAe kēia e hōʻike ʻia i ke kiʻikuhi ma luna me ka ʻole o nā hemahema:
