Nayi chilinganizo chosavuta chomwe chimabwezeretsa tsiku la chaka pa deti loperekedwa. Palibe ntchito yomangidwa yomwe ingachite izi mu Excel.
Lowetsani njira yomwe ili pansipa:
=A1-DATE(YEAR(A1),1,1)+1
=A1-ДАТА(ГОД(A1);1;1)+1
Kufotokozera:
- Madeti ndi nthawi mu Excel zimasungidwa ngati manambala omwe ali ofanana ndi kuchuluka kwa masiku kuyambira Januware 0, 1900. Chifukwa chake June 23, 2012 ndi wofanana ndi 41083.
- ntchito DATE (TSIKU) amatenga zifukwa zitatu: chaka, mwezi, ndi tsiku.
- mawu TSIKU(YEAR(A1),1) kapena Januware 1, 2012 - chimodzimodzi ndi 40909.
- Fomula imachotsa (41083 - 40909 = 174), imawonjezera tsiku limodzi, ndikubwezeretsa nambala yatsiku mchaka.