Formula required

I have list of validations in A1 (eg. start, process, stop); In B1, C1 and D1 – I want the date when A1 has the values Start, Process and Stop respectively – i.e, B1 should capture the date when A1 has the value ‘start’, D1 should capture the date when A1 has the value ‘stop’

 

To be specific – A1 values will keep changing however the date when the list item is first selected should be captured in B1,C1 and D1 and should not vanish once the selection changes in A1

By: A

Leave a Reply

Your email address will not be published. Required fields are marked *