Data Validation Question

[SDowse]

Hi,

I have a spreadsheet that contains all sorts of information. The column I am interested in is U (range is currently U9:U100 although that may change as new rows are added) which contains date information. What I want to do is add data validation of some sort to the column to stop people being able to enter a date that is either a Saturday or Sunday (maybe a pop-up box or something as well??).

Any ideas if this can be done?

Many thanks in advance.

 

[T. Valko]

Hi,

I have a spreadsheet that contains all sorts of information. The column I am interested in is U (range is currently U9:U100 although that may change as new rows are added) which contains date information. What I want to do is add data validation of some sort to the column to stop people being able to enter a date that is either a Saturday or Sunday (maybe a pop-up box or something as well??).

Any ideas if this can be done?

Many thanks in advance.

You can use a formula like this as the data validation rule:

=AND(INT(U9)=U9,WEEKDAY(U9,2)<6)

 

[Smitty]

See: http://www.contextures.com/xlDataVal07.html#Weekend

HTH,