It sounds like you haven't entered your holidays properly. What's in the
Holidays range? And, what answer do you get, and what do you expect?

Regards,
Fred.

"Judy L" wrote in message
...
Hi, I have a workbook that is layed out as follows:

Date Submitted / Date Expired / Date Approved / Duration

Date expired = 10 working days after Date Submitted minus Holidays

I tried this formula

=if (C6,workday(C6,10,holidays),"")

Which works except if the dates are from Dec 08 to Jan 09
I do get a numerical answer (not an error) but it is the wrong answer
When the dates are from (whatever month) 09 to 09 it works perfectly.


Second problem is calculating the duration.
Number of working days (- holidays) from the Date Submitted to the Date
Approved.

I have this formula but again it doesn't work when counting from 08 to 09.
And I haven't figured out how to exclude the holidays

=if(C6="","",networkdays(C6,if(E6="",today(),E6)))-1

I'm really not that good with excel, so I would appreciate any help
offered.

Thanks in advance