How can I get a row to display the date of the last friday, and every friday before that?

B

Bryan.Cook

I need to record the price of an item every friday. I want the most
recent friday in column G.

I am using the today() function, but obviously that won't work, because
on monday it inserts today's date, rather than the most recent friday.
Then, in every column to the right I want the friday before, until
1/2/06.

I know I can just subtract 7 from the column to the left, but how would
I end this. So each week one new column should become active.
 
B

Bob Phillips

Use =TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,4,5,6,0,1) to get the Friday
previous to today.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to display next Friday from B1 works except on the Friday itself. 4
Can some one modify the thirdfriday code to get me the following d 2
Search closest day in the past from today 2
Remove Every Other Friday 0
How can the font and size of (all) citation numbers be altered? 1
How can I get the day of the week (eg Friday) to display ? 2
Calculate Date automatically in word 2007 1
Search specific column for a variable date 6

Top