HOW TO CALCULATE YOUR EXACT AGE USING EXCEL
In excel there is a way to calculate your exact age [With years ,Months & Days ]
For calculating the age we can use this formula "DATEDIF()"
Suppose the Birth-date of your friend is June 21,1988 .What is your friend's age as on today
We can put all together in one Formula .
Age is 23 Years 10 Months And 17 Days
Function Used Is
= Age is "&DATEDIF(C3,TODAY(),"Y")&" Years,&DATEDIF(C3,TODAY(),"YM")&"Months And "&DATEDIF(C3,TODAY(),"MD")&"Days
In excel there is a way to calculate your exact age [With years ,Months & Days ]
For calculating the age we can use this formula "DATEDIF()"
Suppose the Birth-date of your friend is June 21,1988 .What is your friend's age as on today
We can put all together in one Formula .
Age is 23 Years 10 Months And 17 Days
Function Used Is
= Age is "&DATEDIF(C3,TODAY(),"Y")&" Years,&DATEDIF(C3,TODAY(),"YM")&"Months And "&DATEDIF(C3,TODAY(),"MD")&"Days
No comments:
Post a Comment