holiday

  1. D

    Make cell A1 = "Holiday" if date in cell B1 matches a date of holidays in a range of cells C1:C25

    I have searched days to find an answer to this riddle. I've tried Lookup, HLookup, Vlookup, Match, Index with no success. Make cell A1 = "Holiday" if date in cell B1 matches a date of Holidays in a range of cells C1:C25 Please advise, Thanks in advance.
  2. H

    Holiday and Sickness Calculator

    Hi, I am looking for a Holiday and Sickness calculator template where I could calculate the number of holidays/sickness taken and remaining for the year. My holiday year starts from August to July and is entitled for 20 days + bank holidays. Does anyone has a template who can share? Thanks...
  3. F

    VBA Holiday Dates by Week End Date

    Hi All I'm not sure if something like this is possible so i thought i'd ask. Currently we have a system where we store our holiday dates and we need to update another spreadsheet from this but it is not exported in a friendly fashion for this. Please see below as i have a description of each...
  4. A

    How to stop weekend date input

    Hi everyone I want to avoid users to input a weekend or holiday date in the cell B10. I have a range of holidays and named as 'Holiday'. If user input a date such as 25/12/2018, then the date will automatically change to a day before the holiday or weekend e.g. 24/12/2018 If this is not...
  5. S

    Delete entire row if date in column A is a weekend day or holiday

    Hi guys, Do you know how to delete an entire row if the date in column A is a weekend day or holiday? I am still an Excel newbie and am wondering how to do it. I truly appreciate your help, thank you.
  6. P

    Time error

    Hey guys I have the following formula: =IF(G2=“”,””,IF(NETWORKDAYS(B2,B2,$S$2:$S$22)>0,MIN(18/24,H2)-(MAX(6/24,G2),0)) B column = date S2:S22 = holidays H column = finish time G column = start time what the formula is meant to do is if the date is a Monday - Friday and not a public holiday...
  7. P

    Time and date calculations

    hi all. I am having a little trouble working out a couple of formulas. What I have is the following: column A: DATE column B: START TIME column C: FINISH TIME column D: PUBLIC HOLIDAY DATES what I need to calculate is the following 5 different formulas: 1 formula If the date is between...
  8. P

    Value according to workdays, weekends and holidays

    Hello experts, I am fighting with excel to find out, how to automatically insert value into cells according to workday, weekend and holiday. The following I have: - column F, cells F3:F22 are holiday dates - column A, cells A4:A33 are proper dates (i.e. A4 = 1.4.2018) - column C, cells C4:C33...
  9. SelinaR

    Using WORKDAYS formula with "Holiday" range - not calculating correctly

    Hiya I have read through the forums, but can't seem to find an answer to my unique situation.... Action: I need to calculate 5 working days after a date and include holidays Formula: Using workdays formula and named my holiday range pubhol18 (I have also tried just selecting the range)...
  10. S

    VBA for Rate Resets for Floating Securities

    Hello Everyone, I'm here to request your help with writing code that requires excel to reset (fix rates) for floating rate securities for some specified interval. For example, suppose we use a benchmark of LIBOR at a monthly frequency interval for each 10th of the month. So, we need the 1...
  11. D

    Schedule shift for holiday

    I have a fleet of truck I'm tracking. I need a minimum amount of trucks every day, depending on the day of the week. Right now I am using nested "IF" statements checked against a cell that has the date in it to pull trucks needed number. I have two questions. First I want to be able to shift...
  12. L

    Conditional formatting Question

    Hi guys, Got a problem. I've not used conditional formatting much before and unsure how to get it to work properly for my particular situation. I've got these cells I want the conditional formatting to give me a data bar for whatever number is in the days covered column compared to the...
  13. R

    VB Search a text string

    Hi. I have some script in a form that is looking up a date value from a combo box, and then populating a list box with data from sheet 6 columns where the date is equal to combo box value. Private Sub ComboBox10_Change() UserForm5.ListBox1.Clear ' First Clear the Box...
  14. K

    Time between days No weekends No holidays based on start time

    I need to calculate time in between orders, in hours, minutes and seconds. This calculated time must not include weekends or holidays. I already have a holiday sheet created. Each operator has a different shift start and end time. For example user bwulf shift starts at 8am and ends at 5pm. The...
  15. M

    If/Or formula

    <tbody> A B C D E F G H I J K L M 1 Start date Year End of 1st Year Hol Year start Hol Yr End Accrual Start Date Today Total Days in Service Accrued Holiday Holiday Entitlement Taken Holiday Days Taken Half Holiday Days Taken Holiday Days Remaining Holiday Days 2 20/11/17 31/03/2018...
  16. V

    Calculate TAT

    Start date End date Want to calculate TAT, exclude holiday..??
  17. C

    Conditional formatting over several cells

    Hi, I have a large holiday spreadsheet for my staff. The dates are in columns and their names are in the rows. I want to highlight if two or more people from the same work area are on holiday at the same time. Ideally this will flag when their holiday is added and warn them that they may not...
  18. P

    Dragging Networkdays formula with Holiday dates

    I need help!! I have a rolling schedule where I want to calculate the networkdays, we are now coming up to company close offs and I am trying to add our close off dates by adding the "holiday dates" function I currently have the holiday dates filled in on another page of the workbook and have...
  19. J

    Sum of hours between a range of dates

    Don't know if this is possible but thought someone out there may have some ideas.... Making a holiday work rota and trying to get the sum of the hours taken between two dates This is basically how it looks: Sheet 1 <tbody> Date Rota hours 10/11/2017 10 11/11/2017 7 12/11/2017 10...
  20. S

    Next Monday unless holiday, then Tuesday

    I'm needing a formula that, starting with today (whatever day that may be), returns the date of the following Monday unless it is a holiday, then Tuesday. It would save me so much time if I didn't have to change all the dates on a bunch of paperwork weekly.

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