holiday

I am working on a time card template in excel. I want to use a formula to determine if the date in Column A is a workday (that is not a weekend, Sat / Sun, and not on our list of holidays/closures) I was looking at the Workday function but it did not return a true/false value it just returned a...

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...

Hi I am trying to calculate the start date of the first operation based on the start date of the second operation. Typically this is always going to be 7 days (5 work days) before. I can do this easily by just deducting 7 from the second operations start date however I have a calendar lookup...

I have a formula that correctly returns if a date is a mon-fri, weekend or public holiday. =IF(A11="","",IF(COUNTIF(Sheet2!$G$87:$DO$97,A11),"Public Holiday",IF(WEEKDAY(A11,2)>5,"Weekend","Mon-Fri"))) I need it to now determine if the day is a mon-fri, saturday, sunday or public holiday. Can...

I am trying to prepare holiday data for an import into a resource planning system at work. Human Resources have provided me a spreadsheet of all our sites (100+) and which holidays each site observes from 2019 through to the end of 2025. Sites are listed in column A. The date of the holiday...

Hi There I have created the attached planner/job board and require help in doing the following. 1. Under the days of the week. if a date range is entered i want it to auto colour the cells under days of the week. 2. in the engineer list section if i set and engineer to on holiday or sick, i...

Hi. = Workday(A1,1,[holidays]) For the "holidays" I have no problem with my list: (1/1/19, 1/21/19, 2/18/19, etc.). However, I am making a stock market calendar with different time increments. Sometimes the market closes an hour earlier to observe the upcoming holiday. Thus instead of...

hello, is there a fomula to NOT incude bank hols, sat & sundays? for example:- (a2 ) 23/819 (b2) =a2 + 5days ( not inc sat/sun & bank holiday) = 2/9/19 many thanks in advance KR Trevor3007

I am trying to create a holiday calendar for my office that when the holiday is booked in the table (list) it highlights the days taken in the below calanders. I was pretty sure I could do this by index match until that didnt work that is, so now I am stuck. Has anyone got an idea of how I can...

Good morning could someone please help me out with an INDEX MATCH I'm trying to find dates when people are on holiday. my index are DATES on K27:N27. THE NANE J28:J33. THE HOLIDAYS H29:K28 H28 is the name H29 is the letter H so I'm trying to find the name and then the H and return the...

Hi All, I want to make a drop down list to pull the data from the month sheets, showing colour box in the Calendar year sheet. But for each Staff is showing only there own data at the time from the drop list. I not sure if I use a "choose formula or match formula", but how do I do it...

I have a Key Section see belowH = 1 Full day holidayHD = 0.5 half day holidayI am trying to pull this into a summary sheet to add up. Each staff names are in rows with each have a cell under Jan to a total Holidays, but it adds H as 1, and HD as 1. When I want it to record HD as 0.5 half day...

I've set up a worksheet to calculate holidays. There is a table consisting two columns. On column with dates, which include and days-off (holiday, public holidays and business trips) and another column with types of holiday ("holiday", "Public Holiday" and "business trip"). I use this table for...

Hello, I need help with a code that will only allow certain text strings in the cell. So like data validation however not so restricted. For example restrict the cell to have these: Holiday Course Leave But! I would like users to be allowed to enter other information before or after. For...

I have an add-in I have developed with some VBA code and 2 tables on different sheets. TableA is self contained (i.e. only relevant to the VBA code w/i the UDF in the Add-In). TableB is a Holiday table that I would like to distribute via the Add-In so other using the Add-In need not maintain...

Hello, I would like some sort of data validation, or vba code to stop people entering the wrong information. I have a list of words which gets coloured in conditional formatting. Sometimes people put in the wrong words. For instance i have the word "Holiday" in conditional formatting turn red...

I just might not be looking in the right area. I've been searching for a day an a half now and I seem to be stuck searching (Einstein's Crazy Statement inserted her) Let's say I have a dropdown box in cell A5 with a column header of month. B5 is season C5 is Holiday and D5 is temperature...

Hi I have an excel query and i can not figure it out: I have a list of names in column A and Dates along in Row 1. And under the dates by the names are zeros or BH (Bank Holiday), W (worked), H (Hol) & HF (Half Day Hol) I am trying to get results by looking at the name i want to know when...

Hi All I'm wondering if someone can help please? I will have to explain sheet as I'm on work PC so unable to upload example spreadsheet. I need a formula that will calculate/count how many holidays someone needs based on their shift pattern. Warehouse is open 7 days a week and workers are...

Hi I have sheet1 (project dates) set up like this: Start Date | End Date | Initial 15/01/2019 20/01/2019 BF 16/01/2019 16/01/2019 FB 01/02/2019 14/02/2019 BF 15/02/2019 28/02/2019 FB ...and sheet2 (booked holiday) set up like this: Holiday Date | Initial...