=TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,4,5,6,0,1)

--
HTH

Bob Phillips

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

"gabch" wrote in
message ...

Hi,

How can I get last friday from today() in vba?

Thx


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=547383