I agree! <g

--
Biff
Microsoft Excel MVP


"Jarek Kujawa" wrote in message
...
this one is excellent...

On 20 Mar, 18:44, "T. Valko" wrote:
Another one:

A1 = start date
B1 = end date

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

--
Biff
Microsoft Excel MVP

"Khaledity" wrote in message

...



Hi,

I am doing a vacation tracking sheet for my subordinates, and I want
to count the number of days they have consumed by entering start date
and end date.

Any advice?

Thanks.

Khaledity- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -