Worksheet Function

G

Guest

Hi,
I have a work sheet that cell A1 requires you to enter a date in the
following format DD/MM/YYYY.
What I would like is if a date is entered into that cell that is not a
working day (i.e. Weekend or Bank Holiday) then I would like excel to either
display an error message or make some sort of error sound.....
Is this possible?
Many Thanks,
Glenn Robertson
 
J

JE McGimpsey

Look at data validation in XL Help.

For instance, with A1 active, choose Data/Validation and enter


Allow: Custom
Formula: =WEEKDAY(A1,2)<=5
 

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

Similar Threads

Invalid date if weekend or bank holiday 7
Checking Dates against Bank Holidays 2
validate date entered 3
convert 13.11.2009 general to 13/11/2009 date, how to 1
formula to subtract 60 days from a date (05/25/2010) 2003excel 3
Excel Vba to change displayed year automatically. 14
Excel is seeing the date as dd/mm/yyyy 4
separating date and time 5

Top