YEARFRAC won't turn negative

Question

Hi there,&nbsp;&nbsp;I am wanting the yearfrac formula to turn negative if the 2nd date is before the 1st date. So in the below example it would be -.083 instead of just giving me the difference. Is there a way to do this?

oliverscheurich · Answer

liz123395&nbsp;=IF(A1&lt;B1,YEARFRAC(A1,B1),-YEARFRAC(A1,B1))&nbsp;Would this formula be acceptable? It returns the intended result in my sheet.

sergeibaklan · Answer

liz123395&nbsp;
As variant
=SIGN(B1-A1)*YEARFRAC(A1,B1)

Forum Discussion

YEARFRAC won't turn negative

Share

Resources