Column G is a date column that show the last time a chapter was updated.
I would like the date in Column G to be automatically updated to a static date (example of format: "15 NOV 14") if the following criteria is met:
If Column I, Column N, Column S, Column X, Column AC OR
Column AH = "NEW" or "REVISED"
Otherwise, the pre-existing date in Column G is to remain intact and unchanged.
I've attached a sample spreadsheet.