| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing a cell value for a specific weekday.
Hi again,
Am Tue, 18 Dec 2012 15:34:01 +0100 schrieb Claus Busch: you can also choose Data = Data Validation = Custom and enter the formula (for cell A1): =WEEKDAY(A1)=7 for cell A1 the cell can be custom formatted [<8]General;dd/mm/yyyy So you can enter 7 or any date for Saturday Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| How can I calculate dates and skip a specific weekday? | Excel Discussion (Misc queries) | |||
| Updating Dates to Next Specific Weekday Automatically | Excel Programming | |||
| Testing to see if a specific name has been already assigned to cellor range. | Excel Programming | |||
| Determining specific weekday in a range | Excel Programming | |||
Threaded Mode
