LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee days worked (-Holidays, -weekends, Snow Days, etc) Denise Excel Discussion (Misc queries) 2 December 31st 08 04:37 PM
FORMULA, DAYS WORKED TO VACATION DAYS John5835 Excel Worksheet Functions 2 July 31st 08 09:28 PM
Making weekend days working days - the system cuts the working tim Fluffy Excel Discussion (Misc queries) 1 May 30th 08 10:02 PM
Calculate % of events based on days worked Karen Excel Worksheet Functions 1 January 23rd 07 04:25 AM
Weekend days other than Sat Sun rkk Excel Worksheet Functions 15 January 25th 05 02:31 AM


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"