Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
Profil Sophya
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 54 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
|
|
Varsta din CNP:
Sursa:
http://www.itlearning.ro/forum/viewtopi ... &t=269
=DATEDIF(DATE(MID(E3;2;2);MID(E3;4;2);MID(E3;6;2));TODAY();"y")
Unde E3 e casuta in care este CNP-ul.
Pentru a afla varsta in luni:
=DATEDIF(DATE(MID(E3;2;2);MID(E3;4;2);MID(E3;6;2));TODAY();"m")
Pentru a afla varsta in zile:
=DATEDIF(DATE(MID(E3;2;2);MID(E3;4;2);MID(E3;6;2));TODAY();"d")
---
Data nasterii din CNP:
Sursa:
http://forum.portal.edu.ro/index.php?showtopic=53695
=CONCATENATE(MID(F2;6;2);".";MID(F2;4;2);".";"19";MID(F2;2;2))
_______________________________________
|
|
| |
|
| #2 |
|
|
Cum se extrage varsta in ani, luni si zile din data nasterii:
Se scoate data nasterii din CNP cu formula din prima postare si apoi, daca data nasterii este trecuta in celula H2, in alta celula se scrie urmatoarea formula:
=DATEDIF(H2;TODAY( );"y")&" ani, " & DATEDIF(H2;TODAY( );"ym")&" luni, " & DATEDIF(H2;TODAY( );"md")&" zile"
Daca nu merge, inlocuiti ; cu ,
Sursa:
http://spreadsheets.about.com/od/excels ... nt-age.htm
|
|
| |
|
| #3 |
|
|
How to use DATEDIF function:
https://exceljet.net/excel-functions/ex ... f-function
Unit Result
"Y" Difference in complete years
"M" Difference in complete months
"D" Difference in days
"MD" Difference in days, ignoring months and years
"YM" Difference in months, ignoring days and years
"YD" Difference in days, ignoring years
Assuming in A1 is the date: 02.01.1903, and TODAY()=05.12.2019
If in B1 we put:
=DATEDIF(A1;TODAY();"y") // returns 116
=DATEDIF(A1;TODAY();"m") // returns 1403
=DATEDIF(A1;TODAY();"d") // returns 42706
=DATEDIF(A1;TODAY();"md") // returns 3
=DATEDIF(A1;TODAY();"ym") // returns 11
=DATEDIF(A1;TODAY();"yd") // returns 337
You can replace "y", "m", "d" etc. with values of cells, for example if you put:
y in C1
m in C2
d in C3
md in C4
ym in C5
yd in C6
You could drag the following formula from B1 to B6:
=DATEDIF($A$1;TODAY();C1)
_______________________________________
|
|
| |
|
