I kekahi mau hihia, ʻaʻole hiki ke hoʻonohonoho ʻia nā hanana no kahi lā kikoʻī, akā pili ʻia i kahi lā kikoʻī o ka pule o ka mahina a me ka makahiki - no ka laʻana:
- ʻo ka Pōʻakahi mua o Ianuali 2007 ka Pōʻakahi kaumaha loa o ka makahiki
- ʻO ka Lāpule ʻelua i ʻApelila 2011 - La Defence Air
- ʻO ka Lāpule mua ma ʻOkakopa 2012 – La Kumu
- etc.
No ka hoʻoholo ʻana i ka lā kūpono e hāʻule ai kēlā lā o ka pule, pono mākou i kahi ʻano liʻiliʻi akā paʻakikī:
=ДАТА(B1;B2;B4*7-6)+ОСТАТ(B3-ДАТА(B1;B2;);7)
ma ka ʻōlelo Pelekania
=DATE(B1;B2;B4*7-6)+MOD(B3-DATE(B1;B2;);7)
I ka hoʻohana ʻana i kēia ʻano, manaʻo ʻia ʻo ia
- B1 - makahiki (helu)
- B2 - helu mahina (helu)
- B3 – helu o ka lā o ka pule (Mon=1, Poa=2, etc.)
- B4 - helu helu o ka lā o ka pule āu e pono ai
No ka maʻalahi a me ka hoʻomaikaʻi ʻana i ke ʻano, mahalo nui i ka mea i mahalo ʻia E noho mai kā mākou Forum.
- Pehea e mālama pono ai ʻo Excel i nā lā a me nā manawa
- NeedDate hana mai PLEX add-on