How to calculate number of year working on excell? For example: start date: 1/11/2005.So I wish to know what formula to use for this case. thanks
For Example:Enter today date in Cell A1 & 1-11-2005 in Cell A2In Cell A3 enter this =YEARFRAC(A2,A1)It will give you 5.197 yearsHope it helps
@ Taleb80 - thank you for the formula it works very wonderful! cheers
Copyright © 2018 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.