| 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- .. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Saturday's Date
Try this
=NOW()+7-WEEKDAY(NOW()) "Randal W. Hozeski" wrote in message news:c92Eb.576626$Tr4.1551609@attbi_s03... 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- . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display Saturday's Date
Thanks Mike
Worked great!! -Randy- *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| 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) | |||
Linear Mode
