calculate shifts based on current date

shakilk

New Member
Joined
May 14, 2021
Messages
2
Office Version
  1. 365
Platform
  1. MacOS
hi Guys and girls

need some help. im looking for a formula for : I have staff who will be issued shifts for the full month. now it can vary they might work 8 days a month or they might work 20 days a month. im looking for a formula where I can find out how many shifts they have left for the month on any particular date. for example if its 14th May (today). I was the formula to calculate how many shifts they have left till end of the month.

hope that make sense.

thanks in advance.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

shakilk

New Member
Joined
May 14, 2021
Messages
2
Office Version
  1. 365
Platform
  1. MacOS
here is the example I have attached the picture so on the sheet at the cell AH10 I want to know how many shifts left for rest of the month. for "Adam'
 

Forum statistics

Threads
1,141,816
Messages
5,708,752
Members
421,588
Latest member
Wawie

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
Top