Re: today's date minus input date
If you're using a numeric-formula field to generate the days, you will need to use
ToDays(Today()-[Date])
In your example, using todays date, I get 195 days. Depending on whether your field is indicated to be "Past Due" or not; you may want to use [Date] - Today() instead. In other words, if you use Today() - [Date] you will get a negative number.
If the intent is to indicate the number of days past due, then you may want to modify the formula so it does not output anything if the [Due Date] is still in the future.
If(Today()>[Date],
ToDays([Date]-[Today]),null)
ToDays(Today()-[Date])
In your example, using todays date, I get 195 days. Depending on whether your field is indicated to be "Past Due" or not; you may want to use [Date] - Today() instead. In other words, if you use Today() - [Date] you will get a negative number.
If the intent is to indicate the number of days past due, then you may want to modify the formula so it does not output anything if the [Due Date] is still in the future.
If(Today()>[Date],
ToDays([Date]-[Today]),null)