ABCDEFGHIJKLMNOPQRSTUV
1
2
07/10/2025
3
4
5
Project Start Date
Project End date
Total time duration took
Formula
6
18/07/200615/01/2022
15 Years 5 Months 28 Days
=DATEDIF(A6,B6,"y")& " Years "&DATEDIF(A6,B6,"YM") &" Months " &DATEDIF(A6,B6,"MD")& " Days"'
7
28/01/199927/06/2020
21 Years 4 Months 30 Days
8
25/07/199725/07/2021
24 Years 0 Months 0 Days
9
06/12/201701/04/2022
4 Years 3 Months 26 Days
10
05/09/200712/07/2020
12 Years 10 Months 7 Days
11
19/08/201127/06/2020
8 Years 10 Months 8 Days
12
13
14
15
16
17
NameDOBtodays dateAge as on today
18
Aditya05/01/199907/10/2025
26 Years 9 Months 2 Days
=DATEDIF(B18,C18,"y")& " Years "&DATEDIF(B18,C18,"YM") &" Months " &DATEDIF(B18,C18,"MD")& " Days"
19
Ajay06/08/201907/10/2025
6 Years 2 Months 1 Days
20
Amit21/11/200807/10/2025
16 Years 10 Months 16 Days
21
Ashok27/12/200407/10/2025
20 Years 9 Months 10 Days
22
Prashant08/01/201607/10/2025
9 Years 8 Months 29 Days
23
Praveen18/07/200607/10/2025
19 Years 2 Months 19 Days
24
25
26
27
28
todays date >>>
07/10/2025
29
NameDOBAs as on todayFormula
30
Aditya05/01/199926 Year old
=DATEDIF(B30,$D$28,"Y")& " Year old"
31
Ajay06/08/20196 Year old
=DATEDIF(B30,$D$28,"Y")& " Year old"
32
Amit21/11/200816 Year old
=DATEDIF(B30,$D$28,"Y")& " Year old"
33
Ashok27/12/200420 Year old
=DATEDIF(B30,$D$28,"Y")& " Year old"
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100