Nali ifomula elula ebuyisela usuku lonyaka ngedethi ethile. Awukho umsebenzi owakhelwe ngaphakathi ongenza lokhu ku-Excel.
Faka ifomula eboniswe ngezansi:
=A1-DATE(YEAR(A1),1,1)+1
=A1-ДАТА(ГОД(A1);1;1)+1
Incazelo:
- Izinsuku nezikhathi ku-Excel zigcinwa njengezinombolo ezilingana nenani lezinsuku kusukela ngo-January 0, 1900. Ngakho uJuni 23, 2012 uyafana no-41083.
- Umsebenzi DATE (IDETHI) ithatha izimpikiswano ezintathu: unyaka, inyanga, nosuku.
- Expression IDETHI(UNYAKA(A1),1) noma uJanuwari 1, 2012 - okufanayo no-40909.
- Ifomula ikhipha (41083 – 40909 = 174), yengeza usuku olungu-1, bese ibuyisela inombolo ye-serial yosuku onyakeni.