Find the previous Weekday (thursday)

J

JimDandy

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

Bob Phillips

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

--
HTH

Bob Phillips

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

Ron Rosenfeld

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?
Click to expand...

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

Ron Coderre

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

For a date in A1

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

Does that help?

Regards,

Ro
 
Top