Hi Rein,

A formula cannot convert itself to no formula, but you can
test the date and have the formula return a specific value..

=IF(TODAY()Date(2005,12,31),100, A1*b1)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Rein" wrote in message ...
Hello everyone,

I want the result of a formula to be changed into a fixed value after a
certain date has passed. Does anyone know how to do that?