validate business dates

[roosteroo]

hello all,

i need to validate a range of cells to test whether they are weekdays (or even better: and not holidays).

If any cell is found to be on a weekend, then stop and MsgBox this date is not valid.

thank you so much

 

[roosteroo]

that seems to have solved it (with a 5 instead of a 6)

thank you v much

 

[Joe4]

that seems to have solved it (with a 5 instead of a 6)

Yep, typo on my part. Sorry about that. I meant to say greater than or equal to 6, though greater than 5 does the same thing.