Hi!

Try this:

A1 = start date
B1 = end date

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

This doesn't account for holidays. If you need to account for holidays post
back.

Biff

"Hany ElKady" wrote in message
...
Anyone know how I can calculate the working days between two dates on a
sheet. My working week is from Sunday - Thursday, and the dates are stored
in
pairs with start date and end date.

I am leaveing VB as the last resort for this.

Any Ideas ?

--
Hany ElKady
Professional Services Architect
Technology & Service Delivery