How Excel calculates the date the employee is to be promoted

The specific procedures are as follows:

① the following figure, the new employees are divided into primary, intermediate and advanced so three kinds. The probation period of each grade is not the same, the primary 12 months, intermediate 6 months, advanced 3 months. We'll do the calculations separately and enter the formula in the red box labeled in the D2 cell.

② input is finished, press ENTER enter key, get the result 2014/6/10, because Sun Ning is elementary, so need 1 years time.

③ after verifying that the first result is correct, the mouse moves to the lower-right corner of the cell with the + number fill handle and double click to complete the remaining calculations.

Formula description

The year function asks for the years in the date of entry and exit, the month function for the month of the entry and exit date, the month in which the VLOOKUP function matches the period of the trial, the day function returns the days of the entry date, and the last date dates these days into a date, which is the positive date