Excel Formulas

Need formula that will return previous days date when spreadsheet is opened. Can do that with =Today()-1. What I haven’t been able to figure out is getting Monday to open with Friday’s date. Don’t want weekend dates to calculate.