Set day of week to display in date field
 

I need to have my workbook look for today's date but display Friday's date
each week. For example: Today is Sunday, June 15, 2008, but I want the date
field in my spreadsheet to display Friday, June 20, 2008 and then when I open
it again on Wednesday, June 18, 2008 it should still display Friday, June 20,
2008 and on Friday, June 20, 2008 it should also still display Friday, June
20, 2008.

Is this possible?
--
SaipanRick

Set day of week to display in date field
 

=TODAY()-WEEKDAY(TODAY()+1)+7

--
Gary''s Student - gsnu200791

Set day of week to display in date field
 

Thank You!!
--
SaipanRick


"Gary''s Student" wrote:

=TODAY()-WEEKDAY(TODAY()+1)+7

--
Gary''s Student - gsnu200791