Thread: Set day of week to display in date field
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SaipanRick SaipanRick is offline
external usenet poster
  
Posts: 6
Default 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
Reply With QuoteReply With Quote