| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Saturday's Date
Hi. looking for a bit of formula help
I am using a listbox to display dates, =NOW() and =NOW()+7 ... +14 -21 etc. but would like to have the list display only Saturday dates. How can I tell Excel to display the Saturday of the current week instead of the actual day today? Unless it is actually Saturday. If today is Wednesday the 17th I would like it to display Saturday the 20th. Any help would be appreciated. Thanks -Randy- .. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
| Dates - Need to display date one month prior to user-entered date | Excel Worksheet Functions | |||
| Formula to Display Date n-Workdays from a Certain Date | Excel Discussion (Misc queries) | |||
| X axis date - display beyond latest date. | Charts and Charting in Excel | |||
| Calculating number of Saturday's in a Year | Excel Discussion (Misc queries) | |||
Threaded Mode
