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.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Alexanndra1994
 | Femeie
23 ani
Bucuresti
cauta Barbat
23 - 42 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2247
|
|
Varsta din CNP:
Sursa:
=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:
=CONCATENATE(MID(F2;6;2);".";MID(F2;4;2);".";"19";MID(F2;2;2))
_______________________________________
|
|
| pus acum 11 ani |
|
TonyTzu
Moderator
 Inregistrat: acum 12 ani
Postari: 252
|
|
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:
|
|
| pus acum 9 ani |
|
Mrrrr
AdMiN
Inregistrat: acum 18 ani
Postari: 2247
|
|
How to use DATEDIF 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)
_______________________________________
|
|
| pus acum 5 ani |
|