Thank you so much for the quick response. This is way beyond anything I know but gave it a go and have attached the results. I think it's nearly there.

Instead of returning FALSE or TRUE, can it return Yes or No?

Also, think I may have done something wrong as the drop down list also has my target values??

Once last thing, is this working out network days as we only work Mon-Fri? I also need to factor in the public holidays so they are not counted.

So sorry for list of queries but hope you can help.

Not sure it's relevant but I'm using Excel 2016.

Thanks.

Lynn

Attached Files

Target Workbook.xlsx (11.2 KB, 12 views)