Hello,
I am trying to create this list for work where I can see how long a file has been with a person.
Here is the setup
Column A (List of names) Column B
Smith, John 3/2016
Smith, John 2/2016
Smith, John 01/2015
Doe, Jane 4/2015
Doe, Jane 9/2014
What I want as a result in Column C: the duration
Smith, John would yield in column " 1 yr, 2mo" since he had the file from 01/2015 until 3/2016
Doe, Jane would yield in column C "7mo" since he had the file from 9/2014 to 4/2015
any ideas would be much appreciated!
Bookmarks