calculate workday before x month

Originally Posted by XLS-EXCEL

lol, great minds think alike indeed..

very nice guys. Thanks

Only thing is that the dates appear in the second table underneath the sheet NBVC attached and I wanted the dates to appear in column C (raise date column).

Cos everytime I select a role from the menu in column B, the date shows next to the type of employees in the table below (e.g. the date will appear next to the durations in column B7, B8, B9 or B10 rather than the RAISE DATE cell in Column C3, C4 or C5.

Ofcourse this must be cos of the way I initially explained it, so apologies for this small glitch....

Any Ideas?

Regards

Then I think you want daddylongleg's formula in C3, CSE confirmed and then copied down:

=WORKDAY(INDEX($D$2:$P$2,MATCH(TRUE,($D3:$P3)>0,0)),-VLOOKUP(B3,$A$7:$B$10,2,0))