For your formula, you could use:
Or, for a more accurate calculation (text string output):
|
A |
B |
C |
D |
E |
F |
1 |
EMP_NAME |
FILENO |
BIRTHDATE |
AGE |
|
|
2 |
Employee 1 |
546 |
03/02/1977 |
37 |
37 Years, 11 Months, 4 Days |
|
3 |
Employee 2 |
858 |
1/7/1397 |
hijri date |
hijri date |
error because date is hijri/arabic |
4 |
Employee 3 |
549 |
30/8/1978 |
36 |
36 Years, 4 Months, 8 Days |
|
5 |
Employee 4 |
554 |
03/02/1978 |
36 |
36 Years, 11 Months, 4 Days |
|
6 |
Employee 1 |
770 |
19/11/1978 |
36 |
36 Years, 1 Months, 19 Days |
|
7 |
Employee 1 |
638 |
15/10/1979 |
35 |
35 Years, 2 Months, 23 Days |
|
8 |
Employee 1 |
764 |
13/2/1979 |
35 |
35 Years, 10 Months, 25 Days |
|
9 |
Employee 1 |
843 |
20/2/1399 |
hijri date |
hijri date |
error because date is hijri/arabic |
10 |
Employee 1 |
310 |
2/6/1400 |
hijri date |
hijri date |
error because date is hijri/arabic |
11 |
Employee 1 |
568 |
23/1/1980 |
34 |
34 Years, 11 Months, 15 Days |
|
12 |
Employee 1 |
804 |
06/04/1980 |
34 |
34 Years, 9 Months, 1 Days |
|
13 |
|
|
|
|
|
|
14 |
|
|
|
|
|
|
15 |
|
|
|
|
D2: |
=IFERROR(INT((TODAY()-C2)/365.25),"hijri date") |
16 |
|
|
|
|
E2: |
=IFERROR(DATEDIF(C2,TODAY(),"Y")&" Years, "&DATEDIF(C2,TODAY(),"YM")&
" Months, "&DATEDIF(C2,TODAY(),"MD")&" Days","hijri date") |
17 |
|
|
|
|
|
|
Regards, TMS
Bookmarks