Testing a cell value for a specific weekday.

C

CellShocked

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.
 
K

Kevin@Radstock

Hi
Assuming A1 = week starting date cell and the date is in B1. The formul
in A1: =IF(WEEKDAY(B1)=7,"Saturday","").

or something along those lines!
 
C

CellShocked

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!


Cool. Thanks. I'll work with that for a while.
 
C

Claus Busch

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
 
C

Claus Busch

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top