30% Chotsani Dongosolo Lonse Lokhala Ndi Khodi Yochotsera
Nthawi zambiri, njira yabwino yolowera masiku ovomerezeka ndiyo kugwiritsa ntchito maumboni a cell, monga momwe tawonetsera pachitsanzo. Kuti mulowetse masiku ovomerezeka mwachindunji, mutha kugwiritsa ntchito DATE ntchito. Pansipa pali fomula mu F6 yokonzedwanso ndi ma coded olimba ndi DATE ntchito: = COUPNCD(TSIKU(2019,2,15),TSIKU(2024,1,1),2,0) Ndi zolowetsa izi, COUPNCD imabweretsanso zotsatira zomwezo.
Pezani Code