Ungalubala kanjani usuku lonyaka lwedethi ku-Excel

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.

shiya impendulo