On Wed, 20 Aug 2008 10:50:01 -0700, Lyn wrote:

This function works great if I don't try to exclude the holiday....Here's my
problem, I have columns for the entire month and I need to calculate the
number of weekdays AND the number of weekdays less the holidays....this works
fine if my holidays are in a row i.e. 12/24 and 12/25 (AV5:AV6); however, if
I would like to take the 31st out also, it gives me the #value signal....any
help out there?

A date in your "holiday" range is text. Perhaps when you entered 12/31/2008
you entered a leading <space?
--ron