showing negative numbers

[dzeitler]

I am using this formula to show the amout of days between two dates.
=datedif(today(),a2,"d") this works well as long as the date in cel
A2 is in the future. If todays date is after the the date in cell A
It wont show the days as a negative number as I want it to. insted th
cell shows this. #NUM! can anyone help with this. Thank

 

[Ron de Bruin]

Try this

=A5-TODAY()

The formulas that you can insert with this Add-in are working also this way
http://www.rondebruin.nl/datarefiner.htm

 

[Gary Brown]

Try this formula

=IF(TODAY()>A2,-DATEDIF(A2,TODAY(),"d"),DATEDIF(TODAY(),A2,"d")