A
|
B
|
C
|
D
|
|
1
|
||||
2
|
Date Time Years
|
|||
3
|
||||
4
|
Age of person from DOB
|
01/20/80
|
37 Years, 8 Months, 26 Days
|
|
5
|
From to
|
12/31/12
|
04/14/13
|
0 Years, 3 Months, 14 Days
|
6
|
||||
7
|
Adding Years to a Date
|
31-12-2012
|
30
|
31-12-2042
|
8
|
Number of days
|
31/12/2012
|
31/12/2042
|
10957
|
9
|
Age of person from DOB
Formula to be type at D4 should be
=DATEDIF(C4,TODAY(),"Y") & " Years, " & DATEDIF(C4,TODAY(),"YM") & " Months, " & DATEDIF(C4,TODAY(),"MD") & " Days"
Formula for Number of Years , month and days between two numbers D5
=DATEDIF(B5,C5,"Y") & " Years, " & DATEDIF(B5,C5,"YM") & " Months, " & DATEDIF(B5,C5,"MD") & " Days"
Adding Years to a Date D7
=DATE(YEAR(B7)+C7,MONTH(B7),DAY(B7))
Number of days between two dates D8
=DATEDIF(B8,C8, "d")
