For the tick box, you need to enable the Developer ribbon and insert a check box, then format it as you wish and attach it to the cell in question. Then you can use something like this to insert the date in another cell if it is checked:

=IF(B2<>"",TODAY(),"")

where B2 is the cell with the check box attached to it.


This works fine, thank you