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
|