If you want to have a formula result in a number as to the number of days, you cvan do
ToDays(Today() - [Scheduled date])
The inner part would result in a Duration of 3 days, but a Duration is not a number, it is a sense of time ...
I find it much easier to convert that to the number of days.
If you want to add days to a date it would be like
[Scheduled date] + Days(3)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------