Usually an age calculator helpful to HR departments for calculating the age of employees. It is for the purpose of employee benefits and retirement benefits. We have created an Age calculator in excel. With the help of this calculator, you can calculate the age of an employee at any given point of time. This age […]
Calculates the number of days, months, or years between two dates.
Let me show you how to convert the number of days to year/month/day in the prescribed format “1 year 4 months 25days” in Excel. Convert number of Days to year/month/day format For this, we need to use the DATEDIF function. Syntax for DATEDIF Function: DATEDIF(start_date,end_date,unit) First of all select a blank cell you where we […]