tj umesto 1 god 12 mes 0 dana,
da piše 2 god 0 mes 0 dana?
| Datum_1| Datum_2 | Rezultat|
-----------------------------------------
| 03.03.2022. | 03.07.2022. | 1 god., 12 mes., 0 dana |
Formula u koloni Rezultat je
Code:
=DATEDIF(A2;B2;"y")+1&" god.,"&CHAR(10)&DATEDIF(A2;B2;"ym")+8&" mes.,"&CHAR(10)&DATEDIF(A2;B2;"md")&" dana"
=DATEDIF(A2;B2;"y")+1&" god.,"&CHAR(10)&DATEDIF(A2;B2;"ym")+8&" mes.,"&CHAR(10)&DATEDIF(A2;B2;"md")&" dana"