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

Can some one modify the thirdfriday code to get me the following d 2
get week day of a date 2
Autofill today's date Everyday 2
Search specific column for a variable date 6
Find end of week and insert Data 5
How can I get the day of the week (eg Friday) to display ? 2
Pull the Day of Week out of a Date 2
Set day of week to display in date field 2

Top