Work Week Calculation

D

DennyWilson

New Member
Joined
Mar 1, 2018
Messages
1
My workers work an event that begins on different days in my work week. My work week begins on Sun and ends the following Sat. The event may end in a different work week. Is there a way that I can determine the work weeks from a range of dates and calculate their work hours and pay on a work week by work week basis?
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

R
  • Question Question
Looking for help w Excel formula
Replies
2
Views
129
Dave Patton
D
R
  • Question Question
Auto deleting a date column once the date has passed via VBA
Replies
4
Views
96
RMH2024
R
M
  • Solved
If cell contains specific test then present a message
Replies
9
Views
298
MLC1980
M
S
  • Solved
Hyperlink point to specific cell in another sheet
Replies
2
Views
189
Schturman
S
Z
  • Solved
add number of working days to a specific date (Start Date) to have the (End Date)
Replies
5
Views
365
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top