Hi - I have been carrying out an analysis of which method is the best one to use in order to work out the difference between two dates in years. I have a formula that I think works better than yearfrac and better than deducting the 2 dates and dividing by 365.25.

I would be most grateful if some of you could test this formulas accuracy and confirm that it is indeed the best way.

Here goes (it rounds to 5 dps)

=ROUND(((YEAR(B4))-(YEAR(B3))-1)+((B4-(DATE((YEAR(B4))-1,12,31)))+((DATE((YEAR(B3))+1,1,1))-B3))/365.25,5)

Where B3 is the start date and B4 is the end date... Let me have your thoughts please - any input would be much appreciated.