"Ajit Munj" wrote
Sorry Biff, Its not working! Its giving #Name error.

Think you probably missed out the
significance of Biff's last line <g
Where X = 1 through 7 for Monday through Sunday

Plug a number (1 to 7) into the function to replace the "X",
for e.g.:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)),2)=1))

which'll return 4
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----