Stop counting days and strike through

Hello all,

Been asked to repost here, hopefully someone can help...

Can someone help me perform two tasks on the worksheet i have created and attached,

1, I need to stop the day count once a day has been entered in the progress box (date added in service clearance recieved back cell)

2, Also need to make a function when a Y or Close is entered in the last box the whole row then recieves a strikethrough.


I have never used VBA before...


Can anyone help?

Best Regards

Steve