KyleOliver
New Member
- Joined
- Apr 16, 2016
- Messages
- 31
Re: How to count Sundays worked in a specific month based on a cell value
Hi All,
I need to count the Sundays that an employee worked in a month.
The below table is what I am using.
According to this table the employee has worked one Sunday out of the two Sundays shown in the table.
The formula I used was =COUNTIF(H1:H17">=1") but this counts all the cells in column H where the hours exceed 1 and not the Sundays only.
I don't know what formula to use, please help?
<thead style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</thead><tbody style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</tbody>
Hi All,
I need to count the Sundays that an employee worked in a month.
The below table is what I am using.
According to this table the employee has worked one Sunday out of the two Sundays shown in the table.
The formula I used was =COUNTIF(H1:H17">=1") but this counts all the cells in column H where the hours exceed 1 and not the Sundays only.
I don't know what formula to use, please help?
A | B | C | D | E | F | G | H | |
---|---|---|---|---|---|---|---|---|
1 | 1 | Week Day | Punch Date | Time In | Lunch Start | Lunch End | Time Out | Hours Worked |
2 | 2 | Wednesday | Wed 01-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
3 | 3 | Thursday | Thu 02-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
4 | 4 | Friday | Fri 03-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
5 | 5 | Saturday | Sat 04-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
6 | 6 | Sunday | Sun 05-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
7 | 7 | Monday | Mon 06-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
8 | 8 | Tuesday | Tue 07-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
9 | 9 | Wednesday | Wed 08-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
10 | 10 | Thursday | Thu 09-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
11 | 11 | Friday | Fri 10-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
12 | 12 | Saturday | Sat 11-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
13 | 13 | Sunday | Sun 12-Aug-18 | |||||
14 | 14 | Monday | Mon 13-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
15 | 15 | Tuesday | Tue 14-Aug-18 | |||||
16 | 16 | Wednesday | Wed 15-Aug-18 | 8:00 | 12:00 | 13:00 | 16:00 | 7:00 |
17 | ||||||||
<thead style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</thead><tbody style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">
</tbody>