First post, so hopefully I attached my example properly.
I want to be able to insert "Y" into Column D in order to populate in column E the date in which the "Y" was entered.
I want G to produce the date in which both D & F have "Y".
I have used formula's such as =IF(D9="Y", TODAY(), "") but using the TODAY() makes the date in that cell change whenever the actual date changes.
I was told I may have to create a macro to hard code the data after calculated.
Bookmarks