=WORKDAY(TODAY(),-1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wanna Learn" wrote in message
...
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