So I wish to know what formula to use for this case. thanks
sort by best latest
Enter today date in Cell A1 & 1-11-2005 in Cell A2
In Cell A3 enter this =YEARFRAC(A2,A1)
It will give you 5.197 years
Hope it helps
You can help the HubPages community highlight top quality content by ranking this answer up or down.
@ Taleb80 - thank you for the formula it works very wonderful! cheers
Copyright © 2017 HubPages Inc. and respective owners. Other product and company names shown may be trademarks of their respective owners. HubPages® is a registered Service Mark of HubPages, Inc. HubPages and Hubbers (authors) may earn revenue on this page based on affiliate relationships and advertisements with partners including Amazon, Google, and others.
Copyright © 2017 HubPages Inc. and respective owners.