A client of mine is a project manager and wanted to create a view of his SharePoint task list that showed items due in the next 10 days.
The problem: The filter options in a view let you compare Due Date to [Today] but not to "[Today] + 10". You can't have a formula in the "right-hand side" (bottom box) of you filter expression. We wanted to say "Due Date is less than ([Today]+10)" but it wouldn't accept the phrase [Today]+10.
However, you can create a calculated value column that uses a formula.
In other words, we wanted to say:
due date < Today + 10
but instead we can say:
due date - 10 < Today
So we added a Calculated Value column to the Tasks list. I named the column DueDateMinusTen, and gave it the formula of "[Due Date] - 10", and said that it returned a date. No need to add it to any views except for testing purposes. One interesting thing that we saw was that if Due Date was empty, DueDateMinusTen was 12/20/1899. Huh? Yes - because the null value for a date is really 1/1/1900.
Now that we have the column, we can filter any of our views by using the filter expression DueDateMinusTen < [Today].
Oops, no time for pictures. Maybe later!
--Michael