Show the next 6th working day of the month

[loisluther]

Says, if today is 2nd Nov 2014, the cell will say "10 Nov 2014"
But since today is 13 Nov 2014, the cell will jump to "8 Dec 2014" (as 10 Nov 2014 is now over)

My current formula works but it seems bulky and prone to mistake:

=IF(WORKDAY(EOMONTH(TODAY(),-1),6,holiday!$B1:$B12)>TODAY(),
WORKDAY(EOMONTH(TODAY(),-),6,holiday!$B1:$B12),
WORKDAY(EOMONTH(TODAY(),0),6,holiday!$B1:$B12))

Thanks all in advance!

[loisluther]

Says, if today is 2nd Nov 2014, the cell will say "10 Nov 2014"
But since today is 13 Nov 2014, the cell will jump to "8 Dec 2014" (as 10 Nov 2014 is now over)

My current formula works but it seems bulky and prone to mistake:

=IF(WORKDAY(EOMONTH(TODAY(),-1),6,holiday!$B1:$B12)>TODAY(),
WORKDAY(EOMONTH(TODAY(),-),6,holiday!$B1:$B12),
WORKDAY(EOMONTH(TODAY(),0),6,holiday!$B1:$B12))

Thanks all in advance!