Hi,
I have a sheet Named Master. in Column AC I have a drop down in Rows AC2-AC2195 with Values Yes and No. I am looking for away that when Yes or No is chosen in column AC2-AC2195 the current date is put in Column AD2-AD2195.
Example Cell AC2 has Value of Yes it the date of today 1.27.18...