Anan akwai tsari mai sauƙi wanda ke dawo da ranar shekara don kwanan wata da aka bayar. Babu wani ginanniyar aikin da zai iya yin wannan a cikin Excel.
Shigar da dabarar da aka nuna a ƙasa:
=A1-DATE(YEAR(A1),1,1)+1
=A1-ДАТА(ГОД(A1);1;1)+1
Ƙarin bayani:
- Kwanaki da lokuta a cikin Excel ana adana su azaman lambobin da suka yi daidai da adadin kwanakin tun daga Janairu 0, 1900. Don haka Yuni 23, 2012 daidai yake da 41083.
- aiki DATE (DATE) yana ɗaukar dalilai uku: shekara, wata, da rana.
- Zancen RANAR (SHEKARA (A1),1) ko Janairu 1, 2012 - daidai da 40909.
- Tsarin ya rage (41083 - 40909 = 174), yana ƙara kwana 1, kuma yana mayar da adadin ranar a shekara.