I want to get the current date added into a cell when a tick box is checked in another cell.
I currently have another formula in the date cell which changes its colour when the tick box is checked, but I also want the date automatically added at the same time as it changing colour.
The colour change is working using this formula,
I want the cell to automatically add the date too. Can anyone help with the additional formula and how do I combine them both?