enhance formula

[bigfoot]

i run a report on a monthly basis. column A has an employee number, of which there are about 100, and column C, a date.the dates are entered daily, if an employee. makes an entry for that day. all employees and dates are in one file. i review the column of dates, looking for a missing date. i found a formula, here, that i use, and works for me. =IF(C3=C2+1,"","C2+1"). it works well if one day is missing, but it does not help me if multiple consecutive days are missing. can anyone suggest an enhancement to the formula, to pick up if multiple days are missing. thanks

 

[bigfoot]

i cant make it work for some reason, and i cant send out data from work. please make a change to the dates in the above example. the first 3 dates are now 5/28,5/29,5/30 and the 4th date all with the same employee number. so there are 2 days missing. cant make it come up with the correct answer.

 

[bigfoot]

doing different simulations, if the emp number changes and the date is less than the one above, it does not check for missing days at the end of the month. could that be tweaked. everything else is good. thanks.

 

[West Man]

Just to be clear, when the employee number in the row below changes you want to show all missing dates through the end of the month regardless of the date in the row below

 

[bigfoot]

that is correct. i want to identify, all missing days, for all employess, at all times. thank you.

 

[West Man]

I can't think of a way to do it within this format. The problem is on the last row for an employee, there may be missing dates based on the previous row and also missing dates to the end of the month. And the number of each is variable.