How to calculate worked weekend days
 

Hi Everyone;

I'm using an excel worksheet in order to follow employee attendance. Looks
like this;


Employee
Name 02/04 03/04 04/04 05/04 06/04 Worked

weekend days
Thu Fri Sat Sun Mon

A OFF OFF 23 21 21 2
B 15 OFF OFF 23 21 1
C 17 15 OFF OFF 23 0
D 19 17 17 OFF OFF 1
E 19 19 17 15 OFF 2
F 21 19 19 17 15 2

I cannot find the formula to have the worked weekend days on the last column
automaticly. I've tried SUMPRODUCT function with no success.

Any help will be appreciated. Thanks a lot in advance for your time and
advice.

Regards.

How to calculate worked weekend days
 

Try this...

A1:E1 = dates
A2:E2 = weekdays
A3:E3 = first row of data

Enter this formula in F3 and copy down as needed:

=SUMPRODUCT(--(WEEKDAY(A$1:E$1,2)5),--(ISNUMBER(A3:E3)))

--
Biff
Microsoft Excel MVP


"taco" wrote in message
...
Hi Everyone;

I'm using an excel worksheet in order to follow employee attendance. Looks
like this;


Employee
Name 02/04 03/04 04/04 05/04 06/04 Worked

weekend days
Thu Fri Sat Sun Mon

A OFF OFF 23 21 21 2
B 15 OFF OFF 23 21 1
C 17 15 OFF OFF 23 0
D 19 17 17 OFF OFF 1
E 19 19 17 15 OFF 2
F 21 19 19 17 15 2

I cannot find the formula to have the worked weekend days on the last
column
automaticly. I've tried SUMPRODUCT function with no success.

Any help will be appreciated. Thanks a lot in advance for your time and
advice.

Regards.

How to calculate worked weekend days
 

this is great... thanks a lot, I really appreciate it...

"T. Valko" wrote:

Try this...

A1:E1 = dates
A2:E2 = weekdays
A3:E3 = first row of data

Enter this formula in F3 and copy down as needed:

=SUMPRODUCT(--(WEEKDAY(A$1:E$1,2)5),--(ISNUMBER(A3:E3)))

--
Biff
Microsoft Excel MVP


"taco" wrote in message
...
Hi Everyone;

I'm using an excel worksheet in order to follow employee attendance. Looks
like this;


Employee
Name 02/04 03/04 04/04 05/04 06/04 Worked

weekend days
Thu Fri Sat Sun Mon

A OFF OFF 23 21 21 2
B 15 OFF OFF 23 21 1
C 17 15 OFF OFF 23 0
D 19 17 17 OFF OFF 1
E 19 19 17 15 OFF 2
F 21 19 19 17 15 2

I cannot find the formula to have the worked weekend days on the last
column
automaticly. I've tried SUMPRODUCT function with no success.

Any help will be appreciated. Thanks a lot in advance for your time and
advice.

Regards.

How to calculate worked weekend days
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"taco" wrote in message
...
this is great... thanks a lot, I really appreciate it...

"T. Valko" wrote:

Try this...

A1:E1 = dates
A2:E2 = weekdays
A3:E3 = first row of data

Enter this formula in F3 and copy down as needed:

=SUMPRODUCT(--(WEEKDAY(A$1:E$1,2)5),--(ISNUMBER(A3:E3)))

--
Biff
Microsoft Excel MVP


"taco" wrote in message
...
Hi Everyone;

I'm using an excel worksheet in order to follow employee attendance.
Looks
like this;


Employee
Name 02/04 03/04 04/04 05/04 06/04 Worked

weekend days
Thu Fri Sat Sun Mon

A OFF OFF 23 21 21 2
B 15 OFF OFF 23 21 1
C 17 15 OFF OFF 23 0
D 19 17 17 OFF OFF 1
E 19 19 17 15 OFF 2
F 21 19 19 17 15 2

I cannot find the formula to have the worked weekend days on the last
column
automaticly. I've tried SUMPRODUCT function with no success.

Any help will be appreciated. Thanks a lot in advance for your time and
advice.

Regards.