Forum Discussion
calculating years between 2 dates help
Hi I am having an issue calculating number of years between 2 dates on excel. When i used the dateif function, i get a #name? error and when i yearfrac i get #value! or else a number like 1/3/00 ple...
Since you haven't shared a link with your workbook, you're leaving us to speculate as to the nature of the dates you're working with. I've not been able to force Excel to give me the error messages you refer to, so I'd be hard-pressed to even guess what's happening.
Perhaps this reference will help you troubleshoot for yourself.