excel - delete.entirerow breaks vba function

Sorry. Very understandable.

I have attached my workbook (having deleted some titles to protect sensitive data but does not affect sheet operations/functions at all).

i have highlighted the suspect cell in red highlight. On the A column is where you can add and remove rows with double clicking cells like stated in my first post where you add new service reports to the excel sheet (SR's).

I have also kept a password on it for support of troubleshooting if it were to make any difference at all. the password is "letmein".

Thanks.

P.S. - hmmm... I just noticed something. If I add a new row for new SR entry bu then double click the new row, A column cell to delete new row I get the same problem with the cell highlighted in red. But if I now change the start or end date in the date range section at top right, it will refresh my cell in red highlight. Maybe I am looking in wrong area for issue.