Forum Discussion

liz123395's avatar
liz123395
Copper Contributor
Apr 17, 2024

YEARFRAC won't turn negative

Hi there, 

 

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?

Resources