Each and every employee face the problem that how to Calculate "Length of Service", as "Year, Month & Days" or every person required their age so this problem not solved in excel. The following commands are required to calculate How much you are old ?. However, it is not easy to calculate in excel without the following functions.
Today() = Current Date
Datedif = Date Difference between two dates
"Y" = Years
"YM" = Balance numbers of Months after completing Years
"MD" = Balance numbers of Days after completing Months.
Function =datedif(lowerdate,highestdate, "intervel")
AGE CALCULATOR
You can also enter your date of birth to calculate age and check it.
Keep in mind that You should be Registered members of this blog before it's downloading.
Length of Service Calculator only for Registered members (Click Here)
Length of Service Calculator only for Registered members (Click Here)
0 comments:
Post a Comment