Hi,
I am trying to use a formula to show both positive and negative years, months and days between two date columns. I can get where I want showing a positive or negative number of months using
=IF(L2>M2,-DATEDIF(M2,L2,"M"),(DATEDIF(L2,M2,"M")))
Where column L is "Retail Sale Date" and column...