Jedno pitanje vezano za excel, recimo hocu da kad u jednoj celiji ispisem datum recimo bilo koji u godini u formi XX.XX ili ne bitno XX/XX da mi u drugoj zeljenoj celiji pokaze broj tj pokaze koji je to dan po redu u godini, recimo 22/01 je 22 dan u godini, a 25/02 je 56 dan. Da li postoji neka takva funkcija?
Računanje proteklih dana u tekućoj godini
Zaključano
Zakačeno
Code:
=--TEXT(A1-DATE(YEAR(A1)-1;12;31);"0")
=--TEXT(A1-DATE(YEAR(A1)-1;12;31);"0")
Potpis
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!
Radi!!!!! Extra hvala puno.Lepo si ovo ukombinovao.
Naravno, može i bez TEXT sve dok si siguran da je ćelija formatirana za broj
Code:
=A1-DATE(YEAR(A1);1;)
=A1-DATE(YEAR(A1);1;)
Potpis
Have you found helpful examples, solutions or ideas-in-work, please consider the
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!
following:
• Citation of *actual page* you are going to using is welcome.
• Have you saw "Value Added" examples you are going to incorporate to your
profitable blog, daily job or any money making venture: How about online donation?
↗Ana & Vlade Divac Foundation
Hvala!
Da ne otvaram novu temu a slično je ovoj temi,
Kako da mi ispiše broj sedmice u godini.
Hvala unapred
Kako da mi ispiše broj sedmice u godini.
Hvala unapred
>
Postoji WEEKNUM funkcija. Bilo je govora na formum Ili vidi ovde office support
Potpis
Nije to loše Rembrante, samo što ne bi dodao još malo boje?