Thanks for the quick response.

I have a networkdays formula which is working fine ... i then have the formula to show if days are <=5 then target met. This is fine for a letter but if it's a contract then the target is 8 weeks (40 working days)...so need a fix for this formula

=IF(KR2="","",IF((KR2<=5),"Yes","No"))

the type of document to be prepared is in cell KL2 and is a drop down...so user would pick from following list

Permanent Contract
Temporary Contract No Right to Revert
Temporary Contract with Right to Revert
Variation Letter
Sessional Worker Letter

So 5 day KPI for last 2 and 40 for the first 3...

I don't know if I'm making any sense...I hope so!

Lynn