I am trying to make a formula to measure the number of days between two dates in two different columns. In excel you would just take one date, minus the other date and the output is a number.

When I use the formula "DateColumn"-today(), I would expect to get a number returned. Instead I get a text which says "0 years 0 mons -14 days 0 hours 0 mins 0.00 secs".

Instead of this text I would like it to be just -14, because I need to use this result for another formula. I have the data type set to number, but it still returns this text value. How can I correct this this in the system?