To calculate present and previous work experience in years and months using Excel, you can follow these steps:
1.
Step 1: Ensure your dates are in the correct format in Excel. Use the DATE function to input the start date of employment in one cell and the end date in another cell.
2.
Step 2: Calculate the difference between the two dates using the DATEDIF function. In a new cell, enter the formula `=DATEDIF(start_date, end_date, "ym")` where "ym" specifies you want the result in years and months.
3.
Step 3: Format the cell containing the DATEDIF formula as a number to display the result in years and months.
4.
Step 4: To break down the total months into years and months separately, you can use additional formulas. For example, to extract the years, use the formula `=INT(result/12)` and for the remaining months, use `=MOD(result,12)`.
5.
Step 5: You can also customize the output format further by concatenating the years and months using the "&" operator in Excel. For instance, `=INT(result/12) & " years, " & MOD(result,12) & " months"`.
By following these steps, you can easily calculate and display the present and previous work experience in the desired format of years and months using Excel.