Last friday
 

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

Last friday
 

Depends when you consider your week to start, but

=TODAY()-WEEKDAY(TODAY())-1

Should probably do you. Weekday has various options for teh first day of the
week.

Jeff

"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

Last friday
 

lastFriday = date-(weekday(date,vbFriday)-1)

HTH
--
AP

"gabch" a écrit dans le
message de news: ...

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

Last friday
 

=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