Posts

Showing posts with the label YEAR OF EXPERIENCE FORMULA

Alluri Venkata Sathyanarayana Raju, familiarly known as AVS Raju works in the Indian construction industry and is the founder chairman of Nagarjuna Construction Company Ltd.

Image
AVS Raju was born on 18 April 1937 and hails from a family that has been in the construction for over three generations. He left his village Antervedipalem in  East Godavari District ,  Andhra Pradesh , India, after matriculation at the age of 18 years to make his career in  Hyderabad  and started contributing his share in developing the state in the areas of Industry, Infrastructure, Agriculture and Power. For the last 45 years of his career, he has contributed in promoting many industries around Hyderabad and various parts of Andhra Pradesh while spreading the Construction activity in the country. He was the Secretary and Treasurer of Sri Nagarjuna Cooperative Housing Society Limited in 1975 and presently is its President. He was one of the promoters of M/s Nagarjuna Steels Ltd., during 1975-76, the first company of the present popular Nagarjuna group of Companies in Hyderabad. He was also one of the promoters of Deccan Cements Ltd., during 1983-84 which was the fi...

Calculate length of service in years and months

Image
Q.  Is there an easy way to calculate how long in years and months the employees have been working for my company? A.  Excel can do that, as long as you’ve listed all the employees in a database. If so, place them in an Excel worksheet with their start date in one cell and end date (which would be the current date, I assume) in an adjacent cell. Then insert this formula (where the start dates are in the D column and the end dates in the E column): =DATEDIF(D2,E2,"y") & " years, " & DATEDIF(D2,E2,"ym") & " months ". Here’s what it looks like in Excel (color added for clarity): Be sure to format the D and E columns to display dates (see screenshot below). Just call 6202354309,Grand Offer