Start and End Dates for Consecutive Dates

Hi,

I need help....I have a list of id numbers with absence dates. I need to be able to identify the start and end date of each consecutive absence where start date is column b and end date would be column c with the number of consecutive days in column d. Any single day absence would be included as well. We do not work weekends or holidays.

I have attached a list of my current data.

Please let me know if you need anymore information.

Thanks,

Melissa