Worksheet Function

G

grobertson

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

VBA - exporting serial letters to single documents 0
Publisher is filling blank lines with data 2
Delete Text in Multiple Cells 3
convert 13.11.2009 general to 13/11/2009 date, how to 2
Drop-down calendar for sheet 0
Invalid date if weekend or bank holiday 7
Forcing a date entry format of dd/mm/yyyy 1
Extracting just the time portion 6

Top