bank holiday

  1. Rob_010101

    UK Pro-Rata Holiday Calculator

    Hello, This one has the potential to be quite complicated, as UK holiday law is governed under the Working Time Directive. I have been trying to make a calculator on Excel which calculates holiday entitlement and can also take into account if someone starts employment part-way through the...
    • Rob_010101
    • Thread
    • bank holiday complicated formula excel formula help holiday holiday entitlement sheet uk holiday uk holiday calculator
    • Replies: 6
    • Forum: Excel Questions
  2. D

    Calculate Pay Day

    Calculate pay day I get paid on the first of every month. When this falls on a Saturday or Sunday I get paid on the previous Friday. But when this falls on a Bank holiday I get paid on the previous working day. How do I calculate my pay day?
    • DavidEC
    • Thread
    • bank holiday calculate day paid salary weekend workday
    • Replies: 4
    • Forum: Excel Questions
  3. C

    Warning Message Pop-Up Box

    I have an Excel 2010 Spreadsheet. In Column A I have a list of names and in column B I have a list of dates. I would like to know if it is possible to create a pop-up box that will inform me if any of the names in Column A have worked on a Saturday, Sunday or any Bank Holidays. Column A is...
  4. J

    Count number of instances discounting weekends and Bank Holidays

    Hello, I have this formula to work out the number of instances of "S" appearing within a range. The below formula work brilliantly, however, I cannot get it to incorporate Bank Holidays. I have all the bank holidays listed in a named range called "Holidays". Can any one help with editing the...

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