Days left to work in month

what is a rota? Datedif will give you the number of days difference from two dates. here is an example

or to exclude weekends

It needs to include weekends....

The Rota contains everyday of the month for the member of staff and for each day there are values against them if they are working. E on an early and L if on a late

So for example

01/08/2007 02/08/2007 03/08/2007 04/08/2007
Mike E E L L

This will be for the entire month to the 31st with some days off containing blanks... Then as the days role past i need to know how many lates or earlies the person has left to work...??

Thanks for your help so far