Find the previous Weekday (thursday)

How can I identify the previous Thursday given a date? For instance, if I have a date (08/08/2006) in cell A4 and I need to know what the date is for the previous Thursday (08/03/2006), what formula could identify that date?

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

--
HTH

Bob Phillips

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

"JimDandy" <[email protected]> wrote in
message news:[email protected]...
>
> How can I identify the previous Thursday given a date? For instance, if
> I have a date (08/08/2006) in cell A4 and I need to know what the date
> is for the previous Thursday (08/03/2006), what formula could identify
> that date?
>
>
> --
> JimDandy
> ------------------------------------------------------------------------
> JimDandy's Profile:
http://www.excelforum.com/member.php...o&userid=16578
> View this thread: http://www.excelforum.com/showthread...hreadid=570418
>

On Thu, 10 Aug 2006 12:25:44 -0400, JimDandy
<[email protected]> wrote:

>
>How can I identify the previous Thursday given a date? For instance, if
>I have a date (08/08/2006) in cell A4 and I need to know what the date
>is for the previous Thursday (08/03/2006), what formula could identify
>that date?

=A1-WEEKDAY(A1+2)
--ron

Another alternative.......just in case....

For a date in A1

This formula returns the previous Thursday (unless A1 is already a Thursday):
B1: =+A1-MOD(WEEKDAY(A1)+2,7)

Does that help?

Regards,

Ron

All these responses are very much appreciated. Thank you...