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