Worksheet Function

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

convert 13.11.2009 general to 13/11/2009 date, how to 1
Invalid date if weekend or bank holiday 7
Excel is seeing the date as dd/mm/yyyy 4
validate date entered 3
How to Convert 24/03/2010 as text into 03/24/2010 date format 2
Checking Dates against Bank Holidays 2
formula to subtract 60 days from a date (05/25/2010) 2003excel 3
HYPERLINK using a date in a cell 2

Back
Top