Combination of OFFSET & VLOOKUP formula

Dear All,

Although I'm not an xls expert, I managed so far to solve my own problems except the following:

I have an excel file (see attached sample), where in column B there are multiple repeating names and in column E there is a respective date for each one. What I’m looking is a formula which will do the following calculations:
1) From column B find last time “REN” is written.
2) Differentiate MS and TS from column D. Find last “REN” for TS only.
3) Check if the corresponding date of point 1 in column E is overdue. (Date + 6 months is greater than today).
4) Show somehow overdue items.

For example:
Row 4 shows that “REN” is overdue because in column E 2/01/2011 is 2/1/2011>today (over 6 months) for TS. Whereas, row 22 shows that “REN” is not overdue because 20/5/11 <today (less than 6 months) for MS.

I will very much appreciate any idea/help from an expert!!

Thanks a lot in advance.

Poly