I have an Excel worksheet that has a list of dates 

```
Thursday, May 30, 2013
Friday, May 31, 2013
Monday, June 3, 2013
Tuesday, June 4, 2013
Wednesday, June 5, 2013
Thursday, June 6, 2013
Friday, June 7, 2013
Tuesday, June 11, 2013
Wednesday, June 12, 2013
Thursday, June 13, 2013
Friday, June 14, 2013
Monday, June 17, 2013
Tuesday, June 18, 2013

```

I need to determine if I am missing a date (Weekday only) and insert it with a different color background.

I tried this 

```
=IF(A2=A1+1,"","Missing next day")

```

But it tells me that Saturday is missing (and I am not interested in a weekend).

In the sample data above, **Monday June 10** is missing