Hi all,

I have a data verification drop down created and I am trying to make the
date poplate in certain cells depending on my drop down choice. The main
thing I have found for this would be the "today()" value. The problem with
this though is that the date changes daily. I need this to be a static value.
Any help would be great. Thanks.

=IF(K8="closed", TODAY())