Modifying a "sample" Excel "Movie List" spreadsheet

Yes, thank you for responding.

In the picture/screenshot you may see where I have created a Column labled "Date Added/Date Modified" (for some unknown reason to me, after trying to use a formula I got from an online source, it Auto Filled with the "# Name").

I would like to have the column "Date Added/Date Modified" field (for every individual New Row Entry)

OR

(IF there are ANY Additions/Modifications made to an Existing Row Field preformed, other than the date; i.e.: Adding--a Year released where none extisted before, OR changing/updating the Starring Actor field, OR adding a Director's Name, OR changing the movie Format, OR etc....) "Auto Filled" with the current Date of Entry OR Date of Modification.

(IF necessary I have no problem adding a seperate "Date Modified" column if there will be a conflict attempting an "Auto Fill" with/using two major conditions.)

Please forgive me if this is still confusing...I'm trying to be as detailed as possible so as to obtain the best result.

(My "background" so to speak)

I went through programming classes and received my Associates degree in Computer Information Systems about 15 years ago. I was required to take a Microsoft Systems class that covered Word, Access, Excel, and Powerpoint (not to toot my own horn but, I was pretty darn good at it).

But after receiving my degree (from a community college) I was unable to find work in my field, in my locale. So, as with anything, "If you don't use it, you lose it" applies to me. I can barely remember the basics of C++.net or Sequel or Java (or any of it really) anymore.

This is the reason I ask for a complete "cut and paste" Formula/s; I just don't have the knowledge for deciphering drawn out "code style", written explanations for my problem to solve it; I truly wish I still did! :) I really enjoyed writing code in my thirties.

ANY help you would be able to provide would very much be appreciated.

Again, Thank you.

Gary