30% Kashe Duk Dokoki Tare da Lambar Rage
Gabaɗaya, hanya mafi kyau don shigar da ranakun aiki shine amfani da nassoshin tantanin halitta, kamar yadda aka nuna a misalin. Don shigar da kwanuka masu aiki kai tsaye, zaku iya amfani da aikin DATE. Da ke ƙasa akwai dabara a cikin F6 da aka sake yin aiki tare da ƙima mai ƙima da aikin DATE: = COUPNCD (DATE (2019,2,15), DATE (2024,1,1), 2,0) Tare da waɗannan bayanai, COUPNCD ya dawo da sakamako ɗaya.
Sami Code