Sunday, June 15, 2014

How to use datedif function of excel?

Datedif function in excel is used to calculate the difference in date and expressed either in years or months or both. If you want to find the age of man born on say 9/20/1998 and the current date or date of survey is 6/15/2014. To find out his age in year and month in excel using datedif function,call for the following function =DATEDIF(A1,B1,"y")&"."&DATEDIF(A1,B1,"ym") if you want to express the age in year and month both. In the example below, 15.8 means the man is 15 years and 8 months old. similarly if you want to express the age only in month then call for the following function in excel =datedif(a1,b1,"m") In the example below, 188 means the man is 188 months old. Additionally if you just want to round up with the age expressed in years call for the following function in excel =datedif(a1,b1,"y") In the example below, the numeric value in e1 indicate the age of the man and this figure is rounded only for the number of years.
Hope this will help you to solve your problem related to age calculation in excel. Thank you

No comments:

Post a Comment