I do not think a formula will work, as now continulally changes, and your formula is a circular reference. The only way is using Vba, and so the filetype has to be XLSM to enable macros

A worksheet change event is the way to go, the link should help https://www.extendoffice.com/documen...l-changes.html