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.
Any ideas how to adjust this formula to achieve this?
Thanks!
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.
Excel Formula:
=IFERROR(DATEDIF(TODAY(),M2,"d"),"")
Any ideas how to adjust this formula to achieve this?
Thanks!