We often need to calculate the number of employees from the age of entry, only the artificial to calculate will be a big project, especially when the company staff large, so we need to be able to automatically calculate the age of the method, then tell you how to automatically calculate in Excel table:
Method/Step
1. Open the Excel table file that needs to be edited;
2. Insert a column before the length of the record as a record column for the current date, titled "Current Date", which is the date of the day;
Write "=now ()" In the table on the current date, excluding the double quotes, and then the carriage return automatically displays the day's date, and then copies it to the other table below;
Note: This function does not need to write any arguments in parentheses, just let it be empty,
In the then cell of the Age column, write the formula shown in the figure, in parentheses, the "current date" minus the "entry date" interval is then divided by the number of days in the year 365 (the number of days per year can be filled according to the actual year), and the age of entry is obtained.
Copy the formula above to the other table in the column.
Attention matters
Now () do not fill in the parentheses of this function with any parameters.
The number of days per year is not the same, according to the number of days to fill
The above is how to automatically calculate the number of employees in the Excel table of the method introduction, hope to help everyone!