I-30% ikhuphe nayiphi na iodolo enekhowudi yesaphulelo
Ngokubanzi, eyona ndlela ilungileyo yokufaka imihla esebenzayo kukusebenzisa iireferensi zeeseli, njengoko kubonisiwe kumzekelo. Ukufaka imihla esebenzayo ngokuthe ngqo, ungasebenzisa i-DATE umsebenzi. Apha ngezantsi kukho ifomyula ekwi-F6 esetyenzisiweyo kwakhona ngamaxabiso akhuselweyo kunye ne-DATE function: = COUPNCD(UMHLA(2019,2,15),UMHLA(2024,1,1),2,0) Ngala magalelo, i-COUPNCD ibuyisela isiphumo esifanayo.
Fumana ikhowudi