Conditional Formatting for 1st working day of the month

[tonyshortleighton]

I have a worksheet that has a a row dedicated to working dates. I would like to apply conditional format that highlights the first working date of the month. Due to weekends and bank-holidays it isn't as easy as simply identifying the 1st of each month. Any thoughts on how I could apply conditional format to achieve this?

Tue	Wed	Thu	Fri	Mon	Tue	Wed	Thu	Tue
19/03/2013	20/03/2013	21/03/2013	22/03/2013	25/03/2013	26/03/2013	27/03/2013	28/03/2013	02/04/2013

<tbody>
</tbody>

 

[Andrew Poulsom]

Name that range Holidays, the use:

=E11=WORKDAY(DATE(YEAR(E11),MONTH(E11),0),1,Holidays)

 

[tonyshortleighton]

That's worked. I'd like to take this opportunity to thank you for your patience and assistance today.

Tony

 

[scook22]

Brilliant.