Hello,

I am trying to capture a date stamp in a cell when a certain option has
been selected from a drop down menu. After searching on this forum i
made use of

Function DateAndTime()
DateAndTime = Now
End Function

Essentially I have 2 options in my drop down list. "On Going" and
"Complete"

I have 2 further columns labelled Start Time and Finish Time. I am
trying to capture a date stamp in each column using this formula in
column f

=IF(E3="On Going",DateAndTime(),"")

and this formula in column g

=IF(E3="Complete",DateAndTime(),"")

when I select "On Going" from the drop down list the time is captured
in column f perfectly. However when I select "Complete" it captures
the time in column g but nulls the time previously captured in column f
(when "On Going" was selected) as I have changed the value from the
drop down list. Is there anyway that I can ensure the value captured
in Column f stays?

thanks in advance for any help.