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

Finding the right function & formula 4
regular expressions for various date/time strings 3
Customise a Date to display as something else 2
Auto calculate day of week to week of the year (not as serial) 4
Show dates based on criteria 3
Day of the Week 5
Day of the Week in Excel 2
Working Days of Week and DUE DATE for PAYMENT 4

Top