holidays

Hello, I'm looking for a formula to color cells based on weekends and holidays. In cells L2:AP2 are the days of the month. Using the conditional formatting rules I used the following formula "=WEEKDAY(L$2:AP$2,2)>5" to determine the cells to be formatted. In addition to weekends I would like to...

I have a data set with a column that contains, among other things, dates sorted from oldest to newest. Part of what I’m looking to do is write a sub that goes through the dates and deletes weekends along with other specific holidays. Additionally, if there is a date missing that is not a weekend...

Hello, Is there a function that allows you to skip holidays (not count) when working with date ranges? I don't want to use the WORKDAY.INTL or WEEKDAY, etc. I just want the holidays that I indicate not counted. No matter what day of the week they fall on within my range. Let me know if this...

So have a unique situation. I had to rebuild my entire spread sheet and make it a table. This was because I had to have the auto fill formula feature. After using this new method I've had 0 issues. Now I've ran into a situation that only happens a few times a year, but it can be an...

Hello, I have two tabs in by spreadsheet. "Report" and "Holidays". In the first tab I have data and one column contains dates (format: mm/dd/yyyy). Also, in column A of Holidays tab I have listed several dates. I would like to delete all rows from tab Report which are holidays listed in the...

Hello. Trying to count Networkdays against Todays date (using sheet 2 with holidays) IF date is populated in A1 (start date) AND No date yet populated in A2 (end date). IF there is a date in the (end date) A2, then i want the networkdays (also excluding sheet 2 holidays in A1:A10) to poluate...

formula to calculate the date and time within the business hours by Adding hours and excluding Holidays weekends Any Help

I need to calculate the number of days between two dates, including weekends but excluding holidays. I have a table listing the holiday dates named 'holidays'. Thanks

Hi, I have 31 columns, each representing a day of the month. Below I have 5 rows or so. I need to highlight all columns that are Holidays in the UK calendar. I have managed to get the sheet to highlight weekends, but really struggling to do the same for uk holidays. I have created a...

Hi, Is it possible to send an email to a defined distribution list at the beginning of every week picking up staff holidays in Excel for the week ahead. Not sure if this can be set to run at 9.00am every Monday? Thanks in advance.

Hello: I am trying to create a weekday number by month excluding weekends and holidays. I created a table with a helper column with weekdays, weekends and holidays. Please take a look at column H of the attached file so you can see the logic: Example 1/1/2018 = Holiday 1/2/2018 WD 1 Jan 2018...

I am trying to prepare a list of Monday's which excludes any holidays lists but I can't seem to get it to work. I tried the WORKDAY function but then it skips the Monday and returns the Tuesday. Example Cell C4 is the previous Monday 10/02/17 And holidays are listed in cells J5:J30 which...

I have a sheet where I have the calendar for the entire year. For a working day, the value on the adjacent cell is 0 (zero). Anything other than zero against a date will represent a holiday. A sample week in my calendar is something like this: <tbody> Date Holiday Remarks 22-Jan-2018 0...

Hi, Is there a way to use VLOOKUPS to find a selection of the same reference and add them together to give you a result? For example. I've got this list of Holidays that need to be covered. In Colomn L I have Vlookups that are taking data from another table. In this table the first colomn...

Hi I need to measure time between a start and end event in a workflow as this is a key KPI which I need to report on. The start and end times are shown in extended date form DD/MM/YY HH:MM. However, I need to exclude weekends and also set the working hours e.g 9am - 5pm. I'd also like to...

Hi, I'm new to the boards. So hoping you can help me. I'm using the WORKDAYS formula to calculate due dates for my tasks. I've entered the holidays in the correct format (=Date(YYYY,MM,DD)). The formula will work with the holidays for all except New Year's Day, 1/1. Not sure why. Any...

Hi all, I have a bunch of identical looking excel sheets from all employees in our team listing their annual leaves/holidays. Simplified, they contain a column A with start date and column B with end date, for each of their holidays during the year. Each row represent a holiday during the...

i have the below times I'm trying to calculate the time it takes to complete and order in hours minutes and seconds. I do not want to include weekends and holidays in the calculation. I already setup a holiday schedule. Each operator has a different shift time which should go into the...

Hallo all, I'm working on a sheet for overtime and need the Weekdays to populate under the 1.5 hours column and the Sundays and public holidays to populate in the 2 hours column. Date inserted, I used a simple IF statement to test =IF(B5="Sunday",G5=F5,"") B5 - where date is inserted G5 -...

In this sheet, column H finds the weekly MAX from 01/02/1993 based on the OFFSET values given in columns F and G. The formula in column H is =MAX(OFFSET($B$3,F2,0,1,1):OFFSET($B$3,G2,0,1,1)) The value in H2 is the MAX from 01/02/1993 to 05/02/1993 (calculated from data not shown below) The...