AND/OR/IF function !

[LynnMac2016]

Hi



I haven't been on the forum for a while but in desperate need of help.

I have a spreadsheet that I use to track if my team is meeting specific targets. I need a formula that will do the following:-

1. Will return the number of working days from start to end date. Now I have a basic one that is working i.e. =IF(A2="","",IF(ISTEXT(A2),0,NETWORKDAYS(A2,P2,Hol idays))

2. However, the target number of working days is different dependent on whether the team are preparing a variation letter or a contract. So if it's a variation letter that is being prepared then the team have 5 working days to action. However, if it is a contract, they have 8 weeks from employee's start date to complete this. How can I tweak the formula I am using which is =IF(KR2="","",IF((KR2<=5),"Yes","No")), to allow for 8 weeks if it's a contract?

3. There are three different types of contract i.e. Permanent Contract, Temporary Contract No Right to Revert and Temporary Contract with Right to Revert. This value is in cell KL2 as a drop down pick list.

Thoughts, musings?

I'm at a loss.

Lynn