Heino fomula yakapfava inodzosera zuva regore kune rakapihwa zuva. Iko hakuna yakavakirwa-mukati basa rinogona kuita izvi muExcel.
Isa iyo formula inoratidzwa pazasi:
=A1-DATE(YEAR(A1),1,1)+1
=A1-ДАТА(ГОД(A1);1;1)+1
Tsanangudzo:
- Mazuva uye nguva muExcel zvinochengetwa senhamba dzakaenzana nenhamba yemazuva kubva muna Ndira 0, 1900. Saka 23 Chikumi 2012 yakafanana ne41083.
- basa DATE (DATE) inotora nharo nhatu: gore, mwedzi, uye zuva.
- Tsanangudzo ZUVA(GORE(A1),1) kana Ndira 1, 2012 - zvakafanana ne40909.
- Iyo formula inobvisa (41083 - 40909 = 174), inowedzera 1 zuva, uye inodzosa serial nhamba yezuva mugore.