Consecutive cell count (with a catch)

[oneillc9]

Hi - thank you for viewing and I hope you can help me out.

Quite simply, in column A I have a list of all the dates in 2015 beginning on Jan 1st. For this example, Column B contains a name. Vacation days are entered in column B (marked with a 'V'). In cell B2 I want to add a check for whether or not the person has taken off 10 consecutive weekdays (i.e. 2 weeks holidays) at any point throughout the year.

I'm tempted to write a macro to loop through the cells but desperately want to avoid that. Is this possible using some kind or array formula?

Many thanks in advance.

Date	John
2 Weeks Consecutive Holidays?	[Y/N]
Thu-01-Jan	V
Fri-02-Jan	V
Sat-03-Jan
Sun-04-Jan
Mon-05-Jan	V
Tue-06-Jan	V
Wed-07-Jan	V
Thu-08-Jan	V
Fri-09-Jan	V
Sat-10-Jan
Sun-11-Jan
Mon-12-Jan	V
Tue-13-Jan	V
Wed-14-Jan	V

<tbody>
</tbody>

 

[oneillc9]

Thanks to both of you (iliauk and barry). I managed to take your solutions and expand to meet all of my other (unmentioned) requirements. Such an efficient solution.