Set day of week to display in date field

S

SaipanRick

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?
 

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

Search closest day in the past from today 2
Finding the right function & formula 4
Formula to tell day of week 3
Weekending Date w/Less Than 3 days Assoc. with Prior Month 7
Percentage of month passed formula 1
Value of the first day of a year in a list 5
Using a Date and corresponding weekday to pull amounts 1
Looking for a formula 3

Top