Working with daily bank reconciliations we have to update current info on a spreadsheet, including the date. Of course we have to point to the last business day the bank was open. We use the same file but with new information. Before I joined they had been manually changing the date on every document. I …