Thanks but this would only give me a count of working days. I need a count of
each day of the week between the two days. A count for the number of Mondays,
count for the number of Tuesdays etc...

"FSt1" wrote:

hi
look into the =networkday() formula. it's part of the analysis toolpac and
may not be readily available. check tools Addins.... on the menu bar to see
if it is available. if not it should be on your excel/office install disc.

Regards
FSt1

"Andy" wrote:

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