What we used to do (I think it still works) is create a column namedToday.Create a calculated column using the Today column in the calculation.Delete the Today column.Formula now uses today's date in its calculation.