Hi everyone,

I am looking for some help on the following.
On business days (Yes), it would automatically input a value (400) under
Daily Target

Currently, I have a worksheet that looks like the following...

Date Day Business Day Daily Target
12/1/2006 Friday Yes 400
12/2/2006 Saturday No 0
12/3/2006 Sunday No 0
12/4/2006 Monday Yes 400
etc..

Is it possible to automate excel to recognize 12/1/2006 as a business day,
and assign the value of 400 under Daily Target.

If it is possible, can excel recognize holidays as well?
12/25/2006 Monday (Holiday) ~ not a business day?

I am open to any ideas,

thanks,

PJS