Hello I have a cell formatted as =TODAY()-1 which is fine. The problem is
on Monday I want Friday's date, and of course, I get Sunday's date. How can I
correct this? thanks