searching the startdate after an interruption

[economicsbusiness]

Employee workweek Employee Answer
5000 week 33 5000 week 32
6000 week 33 6000 week 32
5000 week 32 7000 week 31
6000 week 32 8000 week 31
7000 week 33
8000 week 32
8000 week 31
8000 week 27
7000 week 32
6000 week 28
8000 week 33
5000 week 30
7000 week 31

Im looking for a formula that finds the first workweek after an interruption. for example employee worked in week 30 and after an interruption of 1 week his first week is 32, but how? I tried min if but need another criteria.

 

[Peter_SSs]

Welcome to posting at the MrExcel board!

Can we get rid of all the "week" text and deal with numbers?

Excel Workbook
	A	B	C	D	E
1	Employee	workweek		Employee	Answer
2	5000	33		5000	32
3	6000	33		6000	32
4	5000	32		7000	31
5	6000	32		8000	31
6	7000	33
7	8000	32
8	8000	31
9	8000	27
10	7000	32
11	6000	28
12	8000	33
13	5000	30
14	7000	31
Start Week

 

[economicsbusiness]

many thanks!! this helps me a lot!!

 

[Peter_SSs]

many thanks!! this helps me a lot!!

You are welcome.

Not sure if it would be possible with your data, but note that if an employee has more than one break, the formula will return the most recent resumption week.

Excel Workbook
	A	B	C	D	E
1	Employee	workweek		Employee	Answer
2	5000	40		5000	39
3	5000	39
4	5000	37
5	5000	36
6	5000	35
7	5000	30
8	5000	29
9	5000	28
10	5000	26
Start Week (2)

 

[economicsbusiness]

thats exactly what I was looking for . thanks again!

 

[Peter_SSs]

Cheers