Formula for rolling Thursdays

[greenlight]

Is there a way to write a formula to get it to read every Thursday in the past rolling? Something like an =today()-7 would work if it was Thursday, but how do I make it Thurday for today and have that same formula output Thursday still tomorrow? Does that make sense?

 

[TheNoocH]

see if this works

Excel Workbook
	A	B
1	8/16/2009	8/13/09
2	8/17/2009	8/13/09
3	8/18/2009	8/13/09
4	8/19/2009	8/13/09
5	8/20/2009	8/13/09
6	8/21/2009	8/20/09
7	8/22/2009	8/20/09
Sheet7

Excel 2007

Cell Formulas
Range	Formula
B1	=A1-CHOOSE(WEEKDAY(A1),3,4,5,6,7,1,2)
B2	=A2-CHOOSE(WEEKDAY(A2),3,4,5,6,7,1,2)
B3	=A3-CHOOSE(WEEKDAY(A3),3,4,5,6,7,1,2)
B4	=A4-CHOOSE(WEEKDAY(A4),3,4,5,6,7,1,2)
B5	=A5-CHOOSE(WEEKDAY(A5),3,4,5,6,7,1,2)
B6	=A6-CHOOSE(WEEKDAY(A6),3,4,5,6,7,1,2)
B7	=A7-CHOOSE(WEEKDAY(A7),3,4,5,6,7,1,2)

 

[xld]

Try

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

 

[greenlight]

Nice! That works. Thanks!!