Current location - Health Road Network - Medical equipment - How to create an employee record management form using EXCEL, which requires automatic updating of age and length of service over time, and other dynamic data analysis! Thank you!
How to create an employee record management form using EXCEL, which requires automatic updating of age and length of service over time, and other dynamic data analysis! Thank you!
First set the data format as an integer
For example, the employee was born in 1978, joined the work in 2000, then in the cell a variety of fill in:
Age column: = year (Now ()) - 1978
Age column: = year (Now ()) - 2000
Other dynamic data need to be you put forward a specific request!