Hi,

A class has 2 batches for students. Monday, Wednesday, Friday and Tuesday,
Thursday, Saturday. Sunday a holiday.

Students can join in between months. One month is considered as 12 WORKING
SESSIONS.

Column A has joining date of students.

4/2/10
4/3/10

Counting from the starting date, i need a date 12 sessions from the starting
date in column B. 4/2/10 ( Friday ) is joining. So 12 sessions would be on
date 4/28/10. I need this in B2 next to A2.

Column H has list of other holidays for which extra sessions have to be
given. Suppose in the above example, H2 contains 26th of April, (MONDAY) as a
holiday, B2 should display 4/30/10 (add more sessions and give 4/30/10
instead of 4/28/10). If H3 contains 10th MAY, Nothing should change as 12
sessions already get over on 30th April.

Note that, B3 will still display 29th April, (12 sessions from 3rd April.
Not adding extra session here as 26th April is not TUE THURS or SAT )

TIA