hi suhas,
excel file is good and useful but there is a little correction needed. since the date of birth is required to calculate the age hence the column you mention (c) date of joining should be corrected to date of birth.
this file can be used for calculating gratuity since the date of joining is mentioned.
hope you will do the needful.
well done keep it up.
regards
I would like to have the formula by what date a person will achieve 58 years
D O B : 01.06.1958 BY I REQUIRE THE DATE WHEN HE WILL BE ATTAIN 58 YEARS - FORMULA FOR THIS
suhaskhambe thanks for sharing such a nice formula for remarks. very good to see. this will help me to present to the management and will help me in recruitment planning against vacancy. thanks n gbu
Hi,
The best way to calculate the date and days for a new joinee is mentioned below. Please use the below mentioned formulae in excel. Whenever you open the file, the current date along with the updated days will be shown in the data. You will not need to carry out any calculations:
Name of Employee Date of Joining Date (Current) Days (Current)
XYZ 25-Jul-2016 =Today() =Today()/365
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute