Hello,

In my spreadsheet (in cell A4), I have the formula =TODAY(). In cell A3, the formula is: =A4-1. The formula in cell A3 works well Tue-Fri, but when I come into work on Monday, I need cell A3 to display a Friday date and not a Sunday date. Is there any way to modify this formula so it skips over weekends?

Your help is greatly appreciated,
Karen