Gsoftnet

How to calculatre your Length of Service in Excel easily.

Dear Friends,

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.

Now() = Today date
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)

0 comments:

Post a Comment