I want an automatic date generation in a particular cell when a value in the
cell adjacent to it is filled. But I want the date to be static, i.e. if it
is calculated it doesn't change. Can I do this with excel please?

Thanks