How do you calculate dates in excel?

Question

working in excel, I have a list of hire dates for employees - how do I figure out the average tenure?

Answer 1

So easy. Calculate the number of days between today and their hire date. It's the cell with today's date - the cell with their hire date. Format the cell as numeric. It will show the number of days they've been there. Then have a cell with =average(range). I hope that explains it, if not ask again.

I could even email you a sample if you need. "Add details" to your question if you want me to.

Answer 2

If you have the start date, make sure you convert the column into date format. Right click > Format Cells, then under Number, Category: Date. Say it is column H.

Add a second column called Today. In the first data cell in that column, enter =NOW(), to get today's date. Copy that cell across all your rows. Say it is column J.

Add a third column called TOTAL DAYS. In the first data cell, enter =NETWORKDAYS(H2,J2). Copy that cell across all your rows. It will give you the total number of days between the two dates. Say it is column K.

Add a fourth column called AVERAGE. Sum all the rows in TOTAL DAYS or K, =AVERAGE(K2:K99). This will give you the average tenure in days divide by 360 to convert to years.

Answer 3

Try this

http://www.mrexcel.com/archive/Dates/index.html

Good luck