| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
| FORMULA, DAYS WORKED TO VACATION DAYS | Excel Worksheet Functions | |||
| Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
| Calculate % of events based on days worked | Excel Worksheet Functions | |||
| Weekend days other than Sat Sun | Excel Worksheet Functions | |||
Linear Mode
