Not unless you only have 1 other non-date field in which case you could use 'clear other fields' but i'm sure that is not the case .
A macro call could do this easily and you can call the code from multiple places including an action/trigger but you would have to gauge... they are generally not considered a best practice.
It is possible with below macro
SET Doc = ActiveDocument
Call this macro in Sheet triggers..
Note: As Jonathan said using Macros is not good practice, but in this scenario if you don't want to use "Clear Field" triggers then macro is the option.