=IF(WEEKDAY(TODAY())=2,TODAY()-3,TODAY()-1)

--
Gary's Student


"Wanna Learn" wrote:

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