| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set day of week to display in date field
=TODAY()-WEEKDAY(TODAY()+1)+7
-- Gary''s Student - gsnu200791 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
| Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
| How to display date as week number | Excel Discussion (Misc queries) | |||
| in vba for access how do i get the day of the week for a date field? | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
