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 figured there had to be a way to fix it and put =TODAY()-1 in the date box and thought I had nailed it.
Fast forward to today, a Monday…and I realized I needed to point to Friday…but my formula was saying Sunday.
A quick Google search later… =WORKDAY(TODAY(),-1)
Problem Solved!