I require a formula to indicate if a lecturer is on holiday

[john dalton]

Hi I have a workbook that uses course infomation and set dates and time for each day, however I need a fomula that will look at the course lecturers booked holidyas and cancel the relevent course when the appropriate lecturer is on holiday.

I have attached a mock up of what I require, any queris please ask away.

Thanks

JD

[DBY]

Hello
Take a look at the attached reply. It may do as you require but test it out.

Hope this helps.
DBY

[john dalton]

Hi DBY, sorry for the late response, the sheets works very well I have adjusted it slightly so that the displayed day from the drop down box now activates the check date for the formula and it works brilliantly, thank you for your assistanance, much appreciated.

Cheers

JD