Hi all
I run followup on expenses.
I need to approve receipts on a very long list and to verify I do not pay them twice. Also I wish to know when was each receipt approved for payment (month & year).

Vision - 2 columns. Col-A - validation list 1/0. Col-B - condition of some kind that grabs the date on which A was changed into "1".

Cannot use simple (today()) as that would change all the time.

Any ideas?

I'm open to other concepts but trying to refrain VBA as I share the file with other security settings (already thought of code\macro that copy/pastes as value Col-B with a safety pop-up asks for permission)

thanks all in advance!!!!