Date validation

[ragini]

hello everybody,
i am new to excel , and i want to format a particular cell such that it
accepts a date and the date should BE ONLY SATURDAY.
If the date is not saturday a message box should appear and say "please
enter the correct date".
Please let me know step by step.As i am not comfortable using excel.

Thanx,
Ragini.

 

[Bob Phillips]

Ragini,

Use Data Validation, setup a custom criteria, and use a formula of
=WEEKDAY(A1)=6
or whatever cell you are inputting data in

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ragini]

Dear bob,
i tried out the tip you have give but thats allowing me to do the
operation,can you please do that in a excel worksheet and send it to
me,that wud be really of great help for me.

thanx
Ragini

 

[Judy Freed]

This is a link to some documentation that I created for my users on Data
Validation. It may help

http://www.uncc.edu/sysdev/HowTos/Excel/Using Data Validation In Excel.htm

http://www.uncc.edu/sysdev/HowTos/Excel/Using A Drop Down List for Data Validation.htm

http://www.uncc.edu/sysdev/HowTos/E...ation to Avoid Duplicate Entries in Excel.htm

 

[Bob Phillips]

Ragini,

It's on its way.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)