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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

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,715
Messages
5,708,058
Members
421,541
Latest member
Akidev

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