Hey,

I have a problem with the today Function. It appears that it changes
each day.
But that isn't what I want! I'd like to have a funtion that puts the
current Date in a field when Data is being added in the Row and then
having this date static the next day.
Here is what I had so far but I have no clue to make the date static:

=IF(C100;TODAY();IF(D100;TODAY();" "))

in this case it checks for information in field C10 and D10 and if
there is information it will add a Date like 2006-03-22. But new day
the field will change to 2006-03-23 and that is not what i want. I want
it to stay the same when data is put in and the date is being
presented.

Thanks for your help already,
Kilian


--
kscramm
------------------------------------------------------------------------
kscramm's Profile: http://www.excelforum.com/member.php...o&userid=32695
View this thread: http://www.excelforum.com/showthread...hreadid=525132