help with business dates please

[roosteroo]

hello all,

i need to validate a range of cells which contain dates to test whether they are weekdays.

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

Please help me out, thank you so much

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=579859

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).