Insert Static Date when another cell is changed.
Good Morning. I am needing some help with inserting a static date. I have my sheet setup where Column C is a pulldown menu for cells C5-C99 with the options of Not Started, In Progress, and Completed. When the cell changes to completed I want Column F to populate the static date in the same row.
Any help would be appreciated.
Thanks
|