Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing a cell value for a specific weekday.
I either want to set up a data validation formula, or do something similar to IF(ISBLANK()) kind of thing. I want a cell called "week starting date" to be locked to only Saturdays (or a numeric test where I can choose which day gets tested). So the user would choose the 'week starting day' (or number) in one cell, and then the formula would take that choice and validate entries in another named cell. Or simply raise a flag (message) if it isn't starting on a Saturday. This makes my timesheet calendar begin with the right day first and date the subsequent days correctly. |
#2
|
|||
|
|||
Hi
Assuming A1 = week starting date cell and the date is in B1. The formula in A1: =IF(WEEKDAY(B1)=7,"Saturday",""). or something along those lines! Quote:
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing a cell value for a specific weekday.
On Tue, 18 Dec 2012 08:38:53 +0000, Kevin@Radstock
wrote: Hi Assuming A1 = week starting date cell and the date is in B1. The formula in A1: =IF(WEEKDAY(B1)=7,"Saturday",""). or something along those lines! CellShocked;1608096 Wrote: I either want to set up a data validation formula, or do something similar to IF(ISBLANK()) kind of thing. I want a cell called "week starting date" to be locked to only Saturdays (or a numeric test where I can choose which day gets tested). So the user would choose the 'week starting day' (or number) in one cell, and then the formula would take that choice and validate entries in another named cell. Or simply raise a flag (message) if it isn't starting on a Saturday. This makes my timesheet calendar begin with the right day first and date the subsequent days correctly. Cool. Thanks. I'll work with that for a while. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing a cell value for a specific weekday.
Hi,
Am Tue, 18 Dec 2012 06:28:23 -0800 schrieb CellShocked: Cool. Thanks. I'll work with that for a while. you can also choose Data = Data Validation = Custom and enter the formula (for cell A1): =WEEKDAY(A1)=7 for cell A1 Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#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 |
Reply |
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 |