Calculating Total Time

[SailorGuy]

Thanks in advance for any help this community can provide. I've been tasked to come up with an excel sheet that does two main functions. I've been able to complete the first but the second one is really giving me a hard time.

Basically I need to take the start date for each employee and display the total number of days they have been affiliated with the company. For example I started 05/28/96 so I have 11 years, 10 months, XX days. I have been able to do this using VBA (but if I could figure out a way to get rid of the #VALUE that would be awesome).

The next thing that I need to do that I need help with is take everyone's total time that they have been working at the company and add it together. Ultimate goal is to show the total experience that can be utilized.

There is one requirement. The date format HAS to be entered in yyyymmdd format. If you look at my example I couldn't figure out how to get EXCEL to deal with this so I converted it using Column C. This column will probably be hidden from the end user.

I have attached a copy of my working example. If anyone could help me accomplish this it would be awesome. I'm open to suggestions if anyone has a better idea then using the VBA that I have here.