Adding Consecutive days (with a date from & to)

Hi Guys,

I am trying to work out consecutive days in an excel spreadsheet. This in particular is for leave days (I've also attached a sample file)

Row 1 Col A Col B Col C
Row 2 Name Date From Date To
Row 3 Peter 01-JAN-15 05-JAN-15
Row 4 Peter 06-JAN-15 20-JAN-15

^ in the above example I want to somehow highlight that this person has taken consecutive days of leave (I'm not particularly worried about days or numbers, just that it reports that this person has taken consecutive leave From C3 to B4.

Thanks in advance
samplefile.xlsxsamplefile.xlsx

Hmm... for some reason I cannot download the file you have attached. When I click download it takes me to a login screen (even though I'm already logged in), when I log in again, it loads a page and simply goes back to the login page not downloading the attachment. Maybe I don't have access to download... not sure.

You are a legend! Thank you very much. I'll mark this as solved.