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?


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=570418

Find the previous Weekday (thursday)
 

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

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

Find the previous Weekday (thursday)
 

On Thu, 10 Aug 2006 12:25:44 -0400, JimDandy
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

Find the previous Weekday (thursday)
 

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=570418

Find the previous Weekday (thursday)
 

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


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=570418