I have a formula using IF ie if blank leave blank, if not return current date using NOW(). However, this date is changing daily. Is there something I'm missing where I can ask within the formula to return the date of change and retain that date (instead of it changing daily per the system)?

cheers

just referenced the McGimpsey web page suggested by PEO Sjoblom mid January... thanks.