MrExcel.com - Your One Stop for Excel Tips & Solutions

Date entry & verification

Posted by Jim on August 27, 2001 8:29 PM

After a user enters a date in a particular cell, I want to verify that the date is a Sunday and issue a Try Again message if not. The code for this little bit of logic will need to reside with the file as it is distributed to others. What is the most efficient way to accomplish all this? Thanks in advance!

Posted by anno on August 27, 2001 8:39 PM

jim
take look at data validation in the tools menu. the help topic is pretty good to get you started, but even better is
http://support.microsoft.com/support/kb/articles/Q211/4/85.ASP

Posted by lenze on August 28, 2001 6:51 AM

Anno: Say your cell is B4. Then in Data Validation, use the custom option and enter this formula: =WEEKDAY(B4,1)=1. That will restrict the date to a Sunday.