Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 18th 12, 02:47 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 277
Default 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   Report Post  
Old December 18th 12, 08:38 AM
Member
 
First recorded activity by ExcelBanter: Oct 2012
Posts: 93
Default

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:
Originally Posted by CellShocked View Post
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.
  #3   Report Post  
Old December 18th 12, 02:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 277
Default Testing a cell value for a specific weekday.

On Tue, 18 Dec 2012 08:38:53 +0000, [email protected]
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   Report Post  
Old December 18th 12, 02:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,769
Default 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   Report Post  
Old December 18th 12, 02:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,769
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WEEKDAY() function: display TEXT not numeric weekday tom Excel Discussion (Misc queries) 3 November 21st 06 04:32 PM
How can I calculate dates and skip a specific weekday? Excelman Excel Discussion (Misc queries) 6 September 6th 06 02:47 AM
Updating Dates to Next Specific Weekday Automatically [email protected] Excel Programming 1 August 11th 06 12:23 AM
Testing to see if a specific name has been already assigned to cellor range. windsurferLA Excel Programming 4 May 6th 05 05:31 PM
Determining specific weekday in a range DK Excel Programming 0 September 17th 03 02:40 AM


All times are GMT +1. The time now is 09:53 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017