Hi there, thanks for the help this far. I need the days of the week in
columns however and cannot seem to get the formulae converted to suit. Would
you be able to provide the details to fit this structure?

http://f4.filecrunch.com/files/20080...20bd/Book1.xls

"T. Valko" wrote:

Try this:

A1 = start date
B1 = end date

A3:A9 = Monday, Tuesday, Wednesday, etc, etc

Enter this formula in B3 and copy down to B9:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A$1&":"&B$1-1)),2)=ROWS(B$3:B3)))

--
Biff
Microsoft Excel MVP


"Andy" wrote in message
...
I have a number of records and each has a field of start and end dates.
What
I need to work out is how I can count for each day of the week, how many
days
are included in this date range (excluding the last date).

i.e.

Start: 01/04/2008
End: 12/04/2008.

Monday = 1
Tuesday = 2
Wednesday = 2
Thursday = 2
Friday = 2
Saturday = 1
Sunday = 1