If we remember the the date of joining tpo the field, then we can calculate the exact experience to store in excel.
YEARFRAC(start_date, End_date, [Basis])
Here Start_date is Date of Joining.
End_Date should be todays date for which we can use the function “TODAY()”.
[Basis] is not required to fill up.
Ex: If my Date of Joining is December 18, 2008
In Excel I will write as below:
=YEARFRAC(DATE(2008,12,18),TODAY())
If today is August 20, 2013, My experience will be shown as 4.672222.
No comments:
Post a Comment