Returns # of years, months, and days
Please help! I need a formula that will look at two different date fields and then return a value that would result in the number of years, months, and days as a total. Example:
Column A Column B Column C
1/1/2006 2/21/2007 1 Year, 1 Month, 20 days
I need the formula for Column C... Any help would be greatly appreciated.
Take a look at this link, it may help?
http://www.cpearson.com/excel/datedif.htm
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks