Trying to track names with days, months, and year(s)

**casemanagerny** · 01-01-2012, 09:54 AM

Good day and Happy New Year, I have Excel 2007 at home and 2003 at work. I have a question, I am a case manager and would like to learn a formula(s) that will allow me to list my caseload of names into excel while also listing their days, months, and years in the program. I would like to have a database of names with their arrival dates in the program and have their remaining dates in days, months, and years. Example John Smith, arrival date (I submit 1/1/12), days total (1 days), months total (less than a month), years total (less than a year). Please assist if you can. Thank you

**zbor** · 01-01-2012, 10:33 AM

can you upload example workbook?

**dilipandey** · 01-01-2012, 10:37 AM

Hi casemanagerny,

See the attached file where I have used your description and devised a solution for you. Let us know of this works for you, else please upload a sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**casemanagerny** · 01-02-2012, 09:56 AM

Wow and neat. Thanks and please let you know about my comments in your excel sample I re-uploaded. Have a healthy day.

**Canuck Chuck** · 01-02-2012, 10:25 AM

Here is a solution using DateDif.

**casemanagerny** · 01-02-2012, 10:40 AM

Thanks Chuck and Dili. I google datedif and it's what I have been looking for.

**dilipandey** · 01-02-2012, 12:01 PM

You are welcome casemanagerny,

Earlier I tried using DateDif but later dropped that idea and showed you two calculations as an option(s).

Thankyou chuck for updating this with relevant texts of Years/ Month / days..

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

**jeffreybrown** · 01-02-2012, 12:09 PM

FYI...

Not sure if this will help you or not, but you did say, Home (2007) and work (2003). I was just informed, if using 2007 you need to be careful with the DATEDIF function...

http://www.excelforum.com/excel-work...html?p=2673335

**dilipandey** · 01-02-2012, 12:38 PM

Hi Jeff,

After reading you post, I was also confused but verified the DateDif function on Excel 2010 and glad to learn that it is working perfectly here also.

Regards,
DILIPandey

<click on below 'star' if this helps>