DateDiff to return positive and negative numbers

[marcus314]

Hi,

I searched for a solution, but couldn't find one that fit my specific needs, so I thought I'd turn to this great forum!

I have a date in cell M2 and am wishing to calculate the date difference in days. The formula I created works great when there is a positive difference. However, for anything < 0, the cell is blank. I'm essentially trying to show both positive and negative values.

=IFERROR(DATEDIF(TODAY(),M2,"d"),"")

Any ideas how to adjust this formula to achieve this?

Thanks!

 

[Peter_SSs]

A tweak on Fluff's very simple approach which avoids the need to re-format the cell/column (assuming it was formatted as General to start with)

=N(M2-TODAY())