usually vba is used on this type of problems (pasting the time stamp) in the cell


but for experiment try this one.

go to option->formulas -> check iteration.
in B29 creating a circular reference...
=IF(C29="","",IF(B29="",TODAY(),B29))