Hi!

One way to count the number of specific weekdays between two dates
(inclusive):

A1 = start date
B1 = end date

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)))=1))

I have no idea what you want in the rest of your post!

Biff

"hydro1guy" wrote in message
...
In a given date/time range I want to determine how many Sundays there are
and
on the other full days how many 16 & 8 hourblocks there are. Then I want
to
total each. Plus on the start and finish days determine how the time
breaks
into each block