>45-((date()-[date1])-[date2])
>
James,
Besides my other question, the formula you have above is forcing the first subtraction to be done first. The 45- would cause a problem but you could process the dates as;
(Date() - (Date1-Date2))
Which would give the date that is the same number of days before today as the difference between date1 and date2